PROCEDURES

PROCEDURES

A procedure is a module that performs one or more actions.

Syntax:

Procedure [schema.]name [(parameter1 [,parameter2 …])]

[authid definer | current_user] is

— [declarations]

Begin

— executable statements

[Exception

— exception handlers]

End [name];

In the above authid clause defines whether the procedure will execute under the authority of the definer of the procedure or under the authority of the current user.