Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

PL/SQL output on TOAD

Posted on 2006-11-17
3
Medium Priority
?
17,613 Views
Last Modified: 2013-12-12
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
Comment
Question by:josephsonnd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
Naveen Kumar earned 500 total points
ID: 17966772
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
 

Author Comment

by:josephsonnd
ID: 17967301
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
 

Author Comment

by:josephsonnd
ID: 17967902
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question