EXEC[UTE] (SQL*Plus command)
Execute a PL/SQL function or procedure.
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) -
EXEC :answer := EMP_PAY.BONUS('SMITH')
"Everyone wants results, but no one is willing to do what it takes to get them" - Dirty Harry