Re: recompile procedure problem ...

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 05 Dec 2003 14:50:22 -0800
Message-ID: <1070664656.924392@yasure>

Franz Zahaurek wrote:

> "Giovanni Azua" <bravegag_at_hotmail.com> writes:
> 
> 

>>Hello all,
>>
>>I've got a procedure that even though is
>>valid does not pass the compilation with
>>ALTER PROCEDURE <proc_name> COMPILE;
>>
>>but only by executing the statement...
>>[...]

> 
> 
> Try: ALTER PROCEDURE <proc_name> COMPILE body;
> 

Procedures don't have bodies. All you get from what you suggested is: ERROR at line 1:
ORA-04043: object <object_name> does not exist

There is something else here the OP hasn't told us.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Dec 05 2003 - 16:50:22 CST