OraFAQ Forum: Client Tools » DBMS_OUTPUT.PRINT

Home » SQL & PL/SQL » Client Tools » DBMS_OUTPUT.PRINT_LINE out put in TOAD (11gr2)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476255]

Wed, 22 September 2010 06:33

malhi
Messages: 96
Registered: December 2009
Location: Karachi

Member

How i can get DBMS_OUTPUT.PRINT_LINE out put in TOAD.

Report message to a moderator

Re: DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476256 is a reply to message #476255]

Wed, 22 September 2010 06:37

Littlefoot
Messages: 16998
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.

Report message to a moderator

Re: DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476259 is a reply to message #476256]

Wed, 22 September 2010 06:47

Michel Cadot
Messages: 54246
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Or better, don't use TOAD, use SQL*Plus.

Regards
Michel

Report message to a moderator

Re: DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476265 is a reply to message #476259]

Wed, 22 September 2010 06:55

Littlefoot
Messages: 16998
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.

Report message to a moderator

Re: DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476397 is a reply to message #476265]

Thu, 23 September 2010 01:29

malhi
Messages: 96
Registered: December 2009
Location: Karachi

Member

It is DBMS_OUTPUT.PUT_LINE not DBMS_OUTPUT.PRINT_LINE

Report message to a moderator

Re: DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476399 is a reply to message #476397]

Thu, 23 September 2010 01:45

ramoradba
Messages: 2427
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

Report message to a moderator

Re: DBMS_OUTPUT.PRINT_LINE out put in TOAD [message #476563 is a reply to message #476399]

Fri, 24 September 2010 00:21

malhi
Messages: 96
Registered: December 2009
Location: Karachi

Member

Thanks.......... My Problem is resolved.

Report message to a moderator

Previous Topic:	Unable to connect Error: The networ adaptercould not establish connection
Next Topic:	how can isqlplus available for windows client?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 12:46:16 CDT 2013

Total time taken to generate the page: 0.07472 seconds