| PL/SQL procedure issue [message #667595] |
Sun, 07 January 2018 23:08  |
 |
nicolewells
Messages: 2
Registered: December 2017
|
Junior Member |
|
|
Hello All, I'm new to Oracle PL/SQL and have been trying to run this code but only getting the following message - PL/SQL procedure successfully completed.
SQL> DECLARE
v_num NUMBER:=10;
BEGIN
FOR v_num IN 1..3
LOOP
DBMS_OUTPUT.PUT_LINE(v_num);
END LOOP;
DBMS_OUTPUT.PUT_LINE(v_num);
END;
Help me on this,
Regards
Nicolewells
[EDITED by LF: removed link]
[Updated on: Mon, 08 January 2018 00:07] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: PL/SQL procedure issue [message #667678 is a reply to message #667674] |
Wed, 10 January 2018 07:15  |
 |
Littlefoot
Messages: 21781
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Which SQL Developer is it?
I use TOAD, but also have SQL Developer (version 4.1.3, an old one). I've just downloaded the latest version, 17.4.
In 4.1.3 I don't even see the "dbms output" pane and don't know how to open it (right-click doesn't do anything), but can see the result of DBMS_OUTPUT in "script output" pane once I enable it with SET SERVEROUTPUT ON. There's no "plus sign" either.
In 17.4 is just the same.
It's probably me, but - where is that "dbms output" pane? How to enable it? Oh yes, I know! Google is my friend, but only if I use it - it is in "View" menu > "Dbms output". Right, green plus icon is here!
Oh well.
Thank you, Ed.
|
|
|
|
| Re: PL/SQL procedure issue [message #667687 is a reply to message #667678] |
Wed, 10 January 2018 12:05 |
 |
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
Littlefoot wrote on Wed, 10 January 2018 07:15Which SQL Developer is it?
I use TOAD, but also have SQL Developer (version 4.1.3, an old one). I've just downloaded the latest version, 17.4.
In 4.1.3 I don't even see the "dbms output" pane and don't know how to open it (right-click doesn't do anything), but can see the result of DBMS_OUTPUT in "script output" pane once I enable it with SET SERVEROUTPUT ON. There's no "plus sign" either.
In 17.4 is just the same.
It's probably me, but - where is that "dbms output" pane? How to enable it? Oh yes, I know! Google is my friend, but only if I use it - it is in "View" menu > "Dbms output". Right, green plus icon is here!
Oh well.
Thank you, Ed.
Hmm. I really can't say. As much as I hate the answer "it's just there", that applies. I open SQL Developer it opens with 4 panes. On the entire left side is the pane with with tabs "Reports", "DBA", and "Connections", with "Connections" being the active tab. Extending from there all the way to the right border, on the top, is a pane with the "Start Page" tab. Under that, on the left (but to the right of the "Connections" tab), is a pane labeled "Dbms Output", with the icons I mentioned. To the right of that, and under the "Start Page" is a pane labeled "Messages - Log". When I open a connection, the "start page" pane gets a new tab, which is the worksheet for the connection I just opened. The two lower panes (Dbms output and Messages-Log) are still there. This is with v17 but it was the same with my old v4.
|
|
|
|
| Re: PL/SQL procedure issue [message #667688 is a reply to message #667687] |
Wed, 10 January 2018 13:00 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
I rarely use Sql Devleoper, but based on Ed's response, I started it up. I did not have the DBA windows or dbms_output window, but I went under View from the menu and clicked next to each of those and sure enough those windows showed up.
I used version 4.1.4.21.
[Updated on: Wed, 10 January 2018 13:01] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
).