| DBMS_OUTPUT [message #458524] |
Mon, 31 May 2010 02:56  |
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 #458534 is a reply to message #458527] |
Mon, 31 May 2010 03:08  |
 |
Littlefoot
Messages: 21823
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 #458558 is a reply to message #458534] |
Mon, 31 May 2010 04:30 |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
Littlefoot wrote on Mon, 31 May 2010 13:38Red 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"...] 
By
Vamsi
[Updated on: Mon, 31 May 2010 04:31] Report message to a moderator |
|
|
|
|
|
| Re: DBMS_OUTPUT [message #458583 is a reply to message #458524] |
Mon, 31 May 2010 06:11 |
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 #458606 is a reply to message #458583] |
Mon, 31 May 2010 11:12 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
dhinendra wrote on Mon, 31 May 2010 13:11hi 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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
