Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: recompile procedure problem ...

Re: recompile procedure problem ...

From: Franz Zahaurek <fzk_at_aon.at>
Date: 05 Dec 2003 22:57:01 +0100
Message-ID: <m0u14f9bde.fsf@franz.athome>


"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, Europe
Received on Fri Dec 05 2003 - 15:57:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US