Close popover
Thavamani K (Thavamani)
Cognizant Technology Solutions

Cognizant Technology Solutions
Thavamani Member since 2016 1 post
Cognizant Technology Solutions
Posted: October 23, 2017
Last activity: September 30, 2018

Calling oracle Stored Procedure with xml


I am calling a stored procedure (oracle) which accepts 1 input (XML Type) and returns 1 (XML Type) output and error flag (INTEGER).

I am using a Connect-SQL (browse) tab to call the stored procedure.

When I run the activity which calls RDB-List, it is returning the below error:

Syntax : CALL PPTS.PM_PROCDOC_UPLDI_XML({TVM.input in},{TVM.ouput out},{TVM.Errorlable out})

HERE : PPTS is schema name and PM_DOC_UPLDI_XML is procedure.

Error :

Kindly help us to resolve this issue. Please share if there is any doc to call stored procedure with XML input and out.

Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.