simple_procedure1.htm
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
IS
Begin
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

HR