DECLARE
message varchar2(20):= 'Hello, World!';
BEGIN
dbms_output.put_line(message);
END;
How can I execute above pl/sql program in Oracle SQL Developer. Can any one suggest me?
Add a comment
|
5 Answers
I have tried following the steps shown in this image. Some steps are excluded but I am sure you will understand when you encounter them.
If you do not see DBMS output just add
set serveroutput on
at the top and execute the statements as a script, you will see the output in "Script output" section.
set serveroutput on
DECLARE
message varchar2(20):= 'Hello, World!';
BEGIN
dbms_output.put_line(message);
END;
Comments
Assuming you already have a connection configured in SQL Developer:
- from the
Viewmenu, selectDBMS Output - in the DBMS Output window, click the green
plusicon, and select your connection - right-click the connection and choose
SQL worksheet - paste your query into the worksheet
- run the query
5 Comments
Frank Schmitt
Which version of SQL/Developer are you using? Which language settings? (in my (German) IDE, it's called "DBMS Ausgabe" instead of "Dbms output"))
i am samurai
Frank use ver 4.0 oracle.com/technetwork/developer-tools/sql-developer/overview/…
First execute 'set serveroutput on' query in worksheet then check in View menu, DBMS output option will appear.
Comments
Surround your procedure code accordingly :
create or replace procedure YOUR_TEST as
begin
<proc code here>
end;
/
show errors
Hit the green arrow to compile - you should get the following message :
Procedure YOUR_TEST compiled
Now run it :
exec YOUR_TEST ;
n.b.: env: Oracle 12g, Sql Developer v18.4
