Question

1
Replies
595
Views
ElizabethC0768 Member since 2017 14 posts
Pirs
Posted: 1 year ago
Last activity: 1 year 8 months ago
Closed

Get the value returned by the stored procedure

Hello

I call the stored procedure from the external database and it works correctly. But how I can set value obtained from the stored procedure to the property of the Work-MyClass class.
Below is an example of an activity and XML page that I get when performing activity.

In this activity i call stored procedure.

So, I need to set in the pyWorkPage.temp property the value of the "answer" highlighted in the figure above.

Thanks

***Edited by Moderator: Pallavi to update platform capability tags***

Data Integration Java and Activities Data Integration
Close popover
Moderation Team has archived post
Posted: 1 year ago
Hi,


 


You can use RDB-list activity method to call connect sql which calls stored procedure.

Parameter of RDB-List method  "RequestType" accepts connect-sql name. Inside connect sql you have to write a statement to connect to the procedure.

You can use below snippet to get the output values from stored procedure.

 Call mySchema.myproc{

{Inputpage.Property1},

{Inputpage.Property2},

{Inputpage.Property3},

{Inputpage.Property4 OUT},

{Inputpage.Property5 OUT},

)

Here propety4 and Property5 on Input page holds values returned by the procedure in sequential order.
Share this page LinkedIn
Copied!