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.

Questions