----------------------------------------
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;
/
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;
/