EXEC[UTE]

Execute a PL/SQL function or procedure.

Syntax:

   EXEC [:bind_variable :=] package.procedure;

   EXEC [:bind_variable :=] package.function(parameters);

According to the Oracle documentation EXEC is a SQL*PLUS command but it also supported by Server Manager; and maybe some other tools too.

Example

EXEC :answer := EMP_PAY.BONUS('SMITH')

"Everyone wants results, but no one is willing to do what it takes to get them" - Dirty Harry

Related Commands:

EXECUTE IMMEDIATE

Related Views: