Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 17745
  • Last Modified:

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,
0
josephsonnd
Asked:
josephsonnd
  • 2
1 Solution
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now