var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Am getting PL/SQL out put in SQL PLUS but not in
Oracle SQL Developer environment.
"set Serveroutput on" gives the below msg
"line 1: SQLPLUS Command Skipped: set serveroutput on;"
Is there any separate settings to be made to get out put in Oracle SQL Developer environment.
You have to enable output in SQL Developer window (I *think* that there's the green "+" button in bottom right output window; click it).
I have attached a screen shot of the environment.
Please mark me that which button I have to click to view the PL/SQL out put.
But Am receiving the below response
line 1: SQLPLUS Command Skipped: set serveroutput on
line 1: SQLPLUS Command Skipped: set serveroutput on;
anonymous block completed
It is the 5th tab (Results, Script output, ...
You DON'T "SET SERVEROUTPUT ON"; SET is SQL*Plus command, and you use SQL Developer (which is a completely different tool).
Yes, Am getting out put in SQL PLUS. But not in Oracle SQL Developer.
In SQL PLUS - If I write the code wrongly in any one of the line I need to write the code again from first. Else I have to use note pad.
So that am asking how to run this in Oracle SQL Developer environment.
As you told I tried with all button options (Results, Script Output, Explain, Autotrace, DBMS Output, OWA Output). But None wroks.
What exactly did you try? Enable it by a button in DBMS Output pane (as suggested by Littlefoot) and then run that PL/SQL block as script (F5 button)?
Originally Posted by
Did you consider consulting SQL Developer online help (F1 button) to find meaning of these steps?
As I said: click the green + sign!
PL/SQL out put
Thank You Very Much Littlefoot.
Now I am getting the out put.
Am not having (+) symbol there. But something different. Pls see the attached.
Great Thanks Littlefoot
Never mind the icon; it seems that our SQL Developer versions are different (I have just installed the latest one).
OK, glad you made it work!