Trying to Dispaly output using StoredProcedure but getting Error

Feedback Studio
1

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;

2

Hi @vamsi_b

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

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

3

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

4

No working solution or reply in 3 years and a half.

5

hi @pere - I’m not sure if this is academic alliance related (it came to be because of that tag). I’m not fully understanding the workflow since this is lines of code. What activity are you using for us?

6

Hy @magizoologist,

I don’t fully understand what you mean. It’s not me who opened the thread. As I’m looking for a working solution for my problem and there’s a bunch of already existing and open related threads, I feel it’s probably more useful to use those ones than opening an Nth now one for the same issue.

The activities I’m using are Run query (UiPath.Database.Activities.ExecuteQuery) and Run command (UiPath.Database.Activities.ExecuteNonQuery).

7

Yes, we prefer using a previous thread if it’s related. What is your issue though? I’m not sure if the original poster was still facing the problem

8

I don’t know what’s the DBMS the OP is using, as the syntax differs a bit from the one I use in my Oracle PL/SQL, but in the end he seemed to be facing the same problem as me:

SET SERVEROUTPUT ON; 
[...]
DBMS_OUTPUT.PUT_LINE('Whatever');

It doesn’t work, and not only because you can’t “catch” the results of DBMS_OUTPUT.PUT_LINE() anywhere: Studio will throw an error when trying to run that, and the one and only reason for that is USING SET SERVEROUTPUT ON;.

It took me two weeks of trial & error at work to finally find out what was going out because this is not stated anywhere in the UiPath docs.

9

I’m glad you figured out how to make it work. I’ve changed the tags so this will reroute to our Studio feedback team to review!

Thanks!