EXECUTE privilege is used to call a subprogram directly - PL/SQL Subprograms
Q. To call a subprogram directly, users must have the EXECUTE privilege on that subprogram. By granting the privilege, you allow a user to -- Published on 09 Jul 15
a. Call the subprogram directly
b. Compile functions and procedures that call the subprogram
c. Both A & B
d. None of the above
ANSWER: Both A & B
The EXECUTE privilege is a schema object privilege for procedures. It is granted to the users who execute or compile a procedure which calls it.