Question

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

Calling oracle Stored Procedure with xml

Team,

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
Share this page LinkedIn