Question
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***
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.