@ritabrata7 Hi Team,
I have solved the issue by using SQL-DATA VBO, in BluePrism.
The object contains Action called as Execute is the one to call the Procedure by giving command in query- "EXEC Procedure_Name" and the work is done.
Note : don't forget to set Connection before using any execution or get collection etc object.
And to pass input parameter for Procedure you can use Execution or for getting output from procedure you have to Use Get Text/Get Number as per ur requirement.
For giving "Input parameter and getting output in Collection" the command i used was
SQL_DATA Object >> Get Collection Action >> Query>>" DECLARE @ReconAmt int &"DECLARE @BBDR int " & EXECUTE USP_BRCitiDataReconSumm &[BankBookAmt]&","&[CurrentAccount]&","&[TideAccount]&" SELECT @ReconAmt ,@BBDR"
here u have to declare ur Output parameter first & then Execute the Command , then give input parameter in this format separating by <,> then select the output parameter which u have declared in Starting.
In my case the output was number hence i declared it as int in ur case u can do the respective change.
For collection u need not declare all column name u can simply declare the 1 Column name For.eg: " DECLARE @ReconAmt int " & EXECUTE USP_BRCitiDataReconSumm &[BankBookAmt]&","&[CurrentAccount]&","&[TideAccount]&" SELECT @ReconAmt
You will get the Whole Output without fail.
For any further Query just ping.
I did tried executing a procedure in Oracle Database using Oracle DMDA utility using the same get collection action stage but seems like there is an error. Is the structure of syntax going to be the same while calling a procedure in oracle database as well? Please let me know