Display results in output parameter in Toad

Question

I have a stored procedure in Oracle and I'm using an out parameter in it.. I want to know how to display the output in Toad..

Answer 1

You just need to declare a variable to store the value in, and then do whatever you want with the data afterwards. If you are just wanting to see the output, dbms_output is probably the easiest way to go:

declare
  -- declare variable to store out data in.  Make sure datatype is correct
  v_out VARCHAR2(50);
begin
  -- call procedure, assigning value of out parameter to variable you declared
  my_proc(
    p_in => 3,
    p_out => v_out
  );
  -- display value now in variable
  dbms_output.put_line('Value of p_out: '||v_out);
end;

Answer 2

In the Toad schema browser, click the 'Execute' button, which will generate some test code for calling your procedure, and writing the OUT parameter via dbms_output. Check the output in the dbms_output window (you may need to activate output in the dbms_output window using the two leftmost icons)

Answer 3

In Toad after execution of a query you can see Multiple Options like Data Grid, Auto Trace, DBMS Output etc...

1. Goto option DBMS Output.
2. If Output is Turn Off (Red Dot), then click over it to Turn it On (Green).
3. Now Execute your query with CTRL+Enter
4. This will show result after Poling Frequency Seconds.

Trial Code :

DECLARE 
    c number(4);
BEGIN
    c := 4;
    dbms_output.put_line(c);
END;
/