Home » SQL & PL/SQL » Client Tools » DBMS_OUTPUT (10G)
DBMS_OUTPUT [message #458524] Mon, 31 May 2010 02:56 Go to next message
avikroy22
Messages: 7
Registered: May 2010
Location: BANGALORE
Junior Member

Hi Guys,

I am trying to see a simple output "Hello World" being displayed on the output screen but unfortunately I am not able to see it.Its strange!!!!!!!!!!!!!!

I run the following in TOAD:--

BEGIN

DBMS_OUTPUT.put_line('Hello World');

END;


Now I want to see the output under Views-->DBMS OUTPUT.But strangely I dont see anything.


Can u please tell me why??

The green light on the left of the DBMS Output screen shows Server Output is ON.

Thanks,
Avik
Re: DBMS_OUTPUT [message #458527 is a reply to message #458524] Mon, 31 May 2010 03:03 Go to previous messageGo to next message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I don't think Green Light means on.
If you click on that, it will be on. Try..

By
Vamsi
Re: DBMS_OUTPUT [message #458534 is a reply to message #458527] Mon, 31 May 2010 03:08 Go to previous messageGo to next message
Littlefoot
Messages: 21549
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Red light = off, green light = on.
Sounds simple.

However, it seems that either guys at Quest software made our lives a little bit more complicated than necessary (so red/green doesn't always work as expected), or we are missing something (sometimes).

Therefore, when that happens to me, I turn it on/off several times, toggle polling on/off, open another tab and DBMS_OUTPUT there and go back to the first tab hoping that output will be there. It *usually* helps, but not always. Finally, try to turn editor window off, open a new one and - DBMS_OUTPUT once again.
Re: DBMS_OUTPUT [message #458535 is a reply to message #458527] Mon, 31 May 2010 03:09 Go to previous messageGo to next message
avikroy22
Messages: 7
Registered: May 2010
Location: BANGALORE
Junior Member

its a non clicable button in TOAD..
Re: DBMS_OUTPUT [message #458537 is a reply to message #458535] Mon, 31 May 2010 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 66936
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
quoting BlackSwan:
Those who live by the GUI, die by the GUI.


Use SQL*Plus.

Regards
Michel
Re: DBMS_OUTPUT [message #458540 is a reply to message #458537] Mon, 31 May 2010 03:13 Go to previous messageGo to next message
Littlefoot
Messages: 21549
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is "non clicable"?

People die from SQL*Plus too.
Re: DBMS_OUTPUT [message #458558 is a reply to message #458534] Mon, 31 May 2010 04:30 Go to previous messageGo to next message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Littlefoot wrote on Mon, 31 May 2010 13:38
Red light = off, green light = on.
Sounds simple.

However, it seems that either guys at Quest software made our lives a little bit more complicated than necessary (so red/green doesn't always work as expected), or we are missing something (sometimes).

Therefore, when that happens to me, I turn it on/off several times, toggle polling on/off, open another tab and DBMS_OUTPUT there and go back to the first tab hoping that output will be there. It *usually* helps, but not always. Finally, try to turn editor window off, open a new one and - DBMS_OUTPUT once again.
Seems my previous post is little vague.
I don't use TOAD now. But what I have observed is:
The Green Button means: "Click Me" to enable the output.
So, it doesn't mean that, if the button is Green in color, the output is enabled.
It's like a [NOT "whatever it shows"...] Laughing

By
Vamsi

[Updated on: Mon, 31 May 2010 04:31]

Report message to a moderator

Re: DBMS_OUTPUT [message #458561 is a reply to message #458558] Mon, 31 May 2010 04:35 Go to previous messageGo to next message
Littlefoot
Messages: 21549
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Red - disabled.
Green - enabled.

/forum/fa/7861/0/

Re: DBMS_OUTPUT [message #458583 is a reply to message #458524] Mon, 31 May 2010 06:11 Go to previous messageGo to next message
dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India
Member
hi avikroy
when you login in toad and write your code i.e-
BEGIN
DBMS_OUTPUT.PUT_LINE('HELLO');
END;
when you press f9 then you got the message PL/SQL PROCEDURE SUCESSFULLY COMPLETED.Then go on DBMS OUTPUT and press on (turn output on )button and when it goes GREEN then again press f9 then you will got the desired output.



Thanks
Dhinendra
Re: DBMS_OUTPUT [message #458599 is a reply to message #458561] Mon, 31 May 2010 08:12 Go to previous messageGo to next message
vamsi kasina
Messages: 2111
Registered: October 2003
Location: Cincinnati, OH
Senior Member
May be I was half-awake at that time. Sad
I checked in some other machine now.
It is working as mentioned by you.

By
Vamsi
Re: DBMS_OUTPUT [message #458606 is a reply to message #458583] Mon, 31 May 2010 11:12 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
dhinendra wrote on Mon, 31 May 2010 13:11
hi avikroy
when you login in toad and write your code i.e-
BEGIN
DBMS_OUTPUT.PUT_LINE('HELLO');
END;
when you press f9 then you got the message PL/SQL PROCEDURE SUCESSFULLY COMPLETED.Then go on DBMS OUTPUT and press on (turn output on )button and when it goes GREEN then again press f9 then you will got the desired output.



Thanks
Dhinendra

Basically you say you have to execute the procedure twice, which does not make sense.
Re: DBMS_OUTPUT [message #458801 is a reply to message #458524] Tue, 01 June 2010 22:52 Go to previous message
dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India
Member
ohh i am so sorry i was wrong the procedure would be like-
1.press the (turn output on) button.(check it must be green)
2.write your code.
3.press f9
you will got the message- PL/SQL PROCEDURE SUCESSFULLY COMPLETED
and output will come.



Thanks
Dhinendra
Previous Topic: script to describe tables
Next Topic: Migration from postgresql to oracle
Goto Forum:
  


Current Time: Wed Apr 08 01:51:12 CDT 2020