Which action would fix the problem and make the PL/SQL procedure usable?

In your database, the current status of a PL/SQL procedure has become INVALID. Which action
would fix the problem and make the PL/SQL procedure usable?

In your database, the current status of a PL/SQL procedure has become INVALID. Which action
would fix the problem and make the PL/SQL procedure usable?

A.
Recompile the PL/SQL procedure.

B.
Modify the procedure to run with a definer’s right.

C.
Modify the procedure to run with an invoker’s right.

D.
Grant the EXECUTE privilege on the PL/SQL procedure to PUBLIC.



Leave a Reply 0

Your email address will not be published. Required fields are marked *