josephsonnd
asked on
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,
1. set serveroutput on size 1000000
2. exec <some procedure>;
The output is viewed on the screen
With TOAD
How to get similar results,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I found what was wrong
There is a toggle on the DBMS output window to show output on/off
Thanks for your help
There is a toggle on the DBMS output window to show output on/off
Thanks for your help
ASKER
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