Create Oracle Stored Procedure example

Following is a basic oracle store procedure example:

CREATE OR REPLACE PROCEDURE procPrintHelloWorld
IS

 usr_id VARCHAR2(20):=' sujan ';
BEGIN
 
  DBMS_OUTPUT.PUT_LINE('Hello World!'|| usr_id);
 
END;
/

To see output on console you need to run following command.

 set serveroutput on size 30000;

Run store procedure:

 EXEC procPrintHelloWorld;

If you get any compilation error, run following command to display it.

SHOW ERRORS