Daniel Morgan wrote:
> 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.
>
Like the actual error, as show by
show error procedure <proc_name>
--
Regards, Frank van Bortel
Received on Sat Dec 06 2003 - 09:19:54 CST
