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.
***Edited by Moderator: Pallavi to update platform capability tags***
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.
Here propety4 and Property5 on Input page holds values returned by the procedure in sequential order.