Trying to Dispaly output using StoredProcedure but getting Error

[vamsi_b (krishna_b)]

Hi,

CAn someone Help me!

I am trying to display the output by using the below store procedure. but i am getting error even after declaring o_w as NULL

SET output on;
DECLARE
in_A varchar2(1000);
in_B varchar2(1000);
in_C varchar2(1000);
in_D varchar2(1000);
o_w varchar2(1000);

BEGIN
in_A := ‘WSYN012’; in_B := ‘1’; in_C :=‘3’; in_D :=‘12’;
/* Call procedure within package, identifying schema if necessary /
MSW_SUPP.QT_CONN.TN_NGSL(in_A,in_B,in_C,in_D,o_w);
/ Display OUT parameters */
db_output.put_line(o_w);END;

[Pratik_Wavhal]

Hi @vamsi_b

Have a look to the below thread. That may help you :-

Assign: There is no row at position 0 Execute Query empty output data table

Hi @shaggz I have one of the working syntax for using Store Procedure in UiPath. This is just an example which is running for me. You can modify as per your requirements. By using below syntax SP will get create in MSSQL :- create procedure ALL_BOI (@productType nvarchar(50), @noOfTrans nvarchar(50), @amountPresent nvarchar(50), @recievedTrans nvarchar(50), @receivedAmt nvarchar(50), @netBilateral nvarchar(50)) AS begin Insert into [Bank of India]([Product Type],[No. of Transactions Present…

Happy Automation

Best Regards
Er Pratik Wavhal

[vamsi_b (krishna_b)]

Thanks for response.

Here i am trying to display the output of o_w value and getting error becoz i am not declaring that o_w value. but still i want to display o_w value.

in SQL developer output is displayed but uipath is throwing error

Regards,
Vamsi