Thursday, October 17, 2013

How to write Procedure Block Name in PL/SQL simple example

----------------------------------------
Syntax:
----------------------------------------
CREATE [OR REPLACE] PROCEDURE [PROCEDURE_NAME](ARGUMENTS {IN / OUT / INOUT} DATA-TYPE)
IS/AS
    CURSOR DECLARATION;
    VARIABLE DECLARATION;
BEGIN
    SQL & PL/SQL STATEMENTS;
EXCEPTION
    ERROR HANDLING;
END;
/