ALTER PROCEDURE my_proc COMPILE;

From: Mark Framness <framnesso_at_my-deja.com>
Date: Tue, 08 Feb 2000 20:58:39 GMT
Message-ID: <87q01u$35h$1@nnrp1.deja.com>

Greetings All

On an OCP practice exam question (for the Develop PL/SQL Program Units exam) there is a question that has me confused.

Proc A calls proc B. Both procs are invalid. What command do you use to recompile both procs?

The answer given is: ALTER PROCEDURE a COMPILE;

The problem I have is that I thought the statement *ONLY* compiles the proc specified. Does it also compile referred procs in the proper order? A colleague thinks it is a trick question of sorts.

My thinking is that proc B is invalid and proc A invalidates when a tries to call B. So to fix this situation we need to first recompile B than we can go ahead and recompile A.

What is going on with that answer? What am I missing?

Thanks

--
From: Mark Framness
http://netnet.net/~farmer/index.html
All standard disclaimers apply anyone who say otherwise is itching for a fight!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 08 2000 - 14:58:39 CST