Database Update tool/ Stored Procedure
Confluence User - 17 Nov, 2023
Hi There ,
We are developing vendor registration application and a approval flow. Once a request is created it will go for approval and once its approved we are required to post the data in oracle. in order to achieve this we created stored procedure on MSSQL server which will execute the API and will return the Output (supplier ID). I know we can execute the stored procedure using database tool in flow but how can i capture the output of the store procedure. which will be used later in the flow to execute some other stored procedures.
Any Help Will be Appreciated.
Thanks
databaseupdatetool;storedprocedure