Home » SQL & PL/SQL » Client Tools » DBMS_OUTPUT.PRINT_LINE out put in TOAD (11gr2)
DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476255] Wed, 22 September 2010 06:33 Go to next message
malhi
Messages: 96
Registered: December 2009
Location: Karachi
Member
How i can get DBMS_OUTPUT.PRINT_LINE out put in TOAD.
Re: DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476256 is a reply to message #476255] Wed, 22 September 2010 06:37 Go to previous messageGo to next message
Littlefoot
Messages: 19504
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Exactly like you wrote it.

In Editor window's bottom part, there are numerous tabs (such as Data Grid and DBMS Output). Go to the DBMS Output tab. Turn output on (a red light bulb should turn green). Execute the script. In a few moments, you should see the output.
Re: DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476259 is a reply to message #476256] Wed, 22 September 2010 06:47 Go to previous messageGo to next message
Michel Cadot
Messages: 58900
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or better, don't use TOAD, use SQL*Plus.

Regards
Michel
Re: DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476265 is a reply to message #476259] Wed, 22 September 2010 06:55 Go to previous messageGo to next message
Littlefoot
Messages: 19504
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oops! I just figured out that I misread it - I was thinking of DBMS_OUTPUT.PUT_LINE, not PRINT_LINE. Sorry; if your DBMS_OUTPUT package really contains PRINT_LINE, you'll have to find another solution. Mine doesn't have it.
Re: DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476397 is a reply to message #476265] Thu, 23 September 2010 01:29 Go to previous messageGo to next message
malhi
Messages: 96
Registered: December 2009
Location: Karachi
Member
It is DBMS_OUTPUT.PUT_LINE not DBMS_OUTPUT.PRINT_LINE
Re: DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476399 is a reply to message #476397] Thu, 23 September 2010 01:45 Go to previous messageGo to next message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
How i can get DBMS_OUTPUT.PRINT_LINE out put in TOAD.


Again

Quote:
It is DBMS_OUTPUT.PUT_LINE not DBMS_OUTPUT.PRINT_LINE


Hope you are sure in this time..
If it so then do as Little foot said enable the button ..
Or
In the main menu go to --> view--> then select dbms_output .
And execute your file you will see it now ..

sriram
Re: DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476563 is a reply to message #476399] Fri, 24 September 2010 00:21 Go to previous message
malhi
Messages: 96
Registered: December 2009
Location: Karachi
Member
Thanks.......... My Problem is resolved.
Previous Topic: Unable to connect Error: The networ adaptercould not establish connection
Next Topic: how can isqlplus available for windows client?
Goto Forum:
  


Current Time: Wed Aug 27 04:11:00 CDT 2014

Total time taken to generate the page: 0.08763 seconds