Question

1
Replies
762
Views
 Elizaveta Chabanova (ElizabethC0768)
Alfa-bank

Alfa-bank
RU
ElizabethC0768 Member since 2017 14 posts
Alfa-bank
Posted: December 18, 2018
Last activity: January 3, 2019
Posted: 18 Dec 2018 6:57 EST
Last activity: 3 Jan 2019 3:48 EST
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
Moderation Team has archived post, 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.
Posted: 2 years ago
Posted: 3 Jan 2019 3:48 EST
Vishal Sinha (sinhv1)
PEGA
Senior Technical Solutions Engineer
Pegasystems Inc.
IN
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.