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

Do you like this post? Please link back to this article by copying one of the codes below.

URL: http://sknath.blogspot.com/2013/08/create-oracle-store-procedure.html HTML link code: <a href="http://sknath.blogspot.com/2013/08/create-oracle-store-procedure.html">Create Oracle Stored Procedure example</a> BB (forum) link code: [url=http://sknath.blogspot.com/2013/08/create-oracle-store-procedure.html]Create Oracle Stored Procedure example[/url]