PL/SQL output on TOAD

With SQL*PLus

1. set serveroutput on size 1000000
2. exec <some procedure>;

The output is viewed on the screen

With TOAD

How to get similar results,
josephsonndAsked:
Who is Participating?
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
open a new sql editor and then run your pl/sql code.

The bottom portion of the toad where you see the results when you a execute a normal sql query has a tab called 'DBMS Output'. Just click on this tab after executing your pl/sql code.

Thanks
0
 
josephsonndAuthor Commented:
nav_kum_v
exec <procedure_name>('123');

click F5 or F9

I get on the dbms output window the following (not getting the output data):

begin
 <procedure_name>('123');
end;
PL/SQL procedure successfully completed
 
If I type on the upper pane

set serveroutput on size 1000000
<procedure_name>('123');

it gives error

ORA-00922: missing or invalid option


0
 
josephsonndAuthor Commented:
I found what was wrong

There is a toggle on the DBMS output window to show output on/off

Thanks for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.