Question
-
-
US
-
Posted: Dec 18, 2018
Last activity: Jan 3, 2019
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***
Posted: 5 years ago
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.
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.