<div>
nav_kum_v<br />
exec &lt;procedure_name&gt;('123');<br />
<br />
click F5 or F9<br />
<br />
I get on the dbms output window the following (not getting the output data):<br />
<br />
begin <br />
&nbsp;&lt;procedure_name&gt;('123');<br />
end;<br />
PL/SQL procedure successfully completed<br />
&nbsp;<br />
If I type on the upper pane<br />
<br />
set serveroutput on size 1000000<br />
&lt;procedure_name&gt;('123');<br />
<br />
it gives error<br />
<br />
ORA-00922: missing or invalid option<br />
<br />
<br />

</div>


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




<div>
I found what was wrong<br />
<br />
There is a toggle on the DBMS output window to show output on/off<br />
<br />
Thanks for your help
</div>


I found what was wrong

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

Thanks for your help

<div>
<div class="content wysiwyg-content">
With SQL*PLus<br />
<br />
1. set serveroutput on size 1000000<br />
2. exec &lt;some procedure&gt;;<br />
<br />
The output is viewed on the screen<br />
<br />
With TOAD<br />
<br />
How to get similar results,
</div>
</div>


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,

PL/SQL output on TOAD

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.