Execute a PL/SQL function or procedure.
Syntax:
EXEC statement EXEC [:bind_variable :=] package.procedure; EXEC [:bind_variable :=] package.function(parameters);
The length of the EXEC command cannot exceed the length defined by SET LINESIZE.
If the EXEC command is too long to fit on one line, use the SQL*Plus continuation
character (a hyphen) -
Example
SQL> EXEC :answer := EMP_PAY.BONUS('SMITH')
Executing directly from the shell (in this case Windows):
C:\> echo execute demoProc|sqlplus demo/password
“Most people approve of capital punishment, but most people wouldn't do the hangman's job” ~ George Orwell
Related Oracle Commands:
EXECUTE IMMEDIATE
PL/SQL Packages