Creating simple Oracle  procedure: 1
  • set serveroutput on; for sql * plus commandline tool
  • Enable Dbms_output enable in SQL Developer.

To open a SQL Worksheet you need to use an existing contention or open new connection < alt+F10, would prompt you to proceed with worksheet, as shown below.



Script ;

create or replace procedure HelloWorld
dbms_output.put_line('you hit a procedure');
End ;
/* set serveroutput on; in sql*plus */
/* dbms out pane in sql developer to be enabled"
EXEC HelloWorld;

Using sql*plus command line tool