Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: recompile procedure problem ...
"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;
-- Franz Zahaurek http://www.fzk.at Vienna, Austria, EuropeReceived on Fri Dec 05 2003 - 15:57:01 CST