CREATE OR REPLACE PROCEDURE [SCHEME.] procedurename
(argument {IN, OUT, IN OUT} data type,....) {IS, AS}
variable declarations:
constant declarations;
BEGIN
PL/SQL subprogram body;
EXCEPTION...
Type: Posts; User: musini.sreedevi; Keyword(s):
CREATE OR REPLACE PROCEDURE [SCHEME.] procedurename
(argument {IN, OUT, IN OUT} data type,....) {IS, AS}
variable declarations:
constant declarations;
BEGIN
PL/SQL subprogram body;
EXCEPTION...