A script-enabled browser is required for this page to function properly.

Procedure Syntax

The procedure specification begins with the keyword PROCEDURE and ends with the procedure name or with the List of formal parameters. The procedure body begins with the keyword IS and ends with the keyword END followed by the optional procedure name.

Syntax

PROCEDURE procedure_name [argument List] IS
[local variable declaration]
BEGIN
statements
[EXCEPTION exception_handlers]
END;

where:

procedure_name Is the unique, user-defined name of the procedure. This name must adhere to ORACLE naming conventions. For more information, refer to your SQL Language Reference Manual.

argument_List Is ({var_name [mode] type [:= value]}[,...])

where:

var_name Is the unique name of a local variable.

mode Is {IN|OUT|IN OUT}.

type Is any acceptable PL/SQL type.

value Is a PL/SQL expression.

local_variable_ declaration Is {var_name type [:= value]}(,...]

statements Are the executable PL/SQL statements.

exception_handler