recompile procedure problem ...

From: Giovanni Azua <bravegag_at_hotmail.com>
Date: Fri, 5 Dec 2003 19:29:44 +0100
Message-ID: <bqqj0p$25ai0p$1@ID-114658.news.uni-berlin.de>

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...

Is there any way e.g. package/API or script that loads a procedure and re-executes it given the name?

What the reason would be that a valid procedure does not pass compilation from
ALTER PROCEDURE <proc_name> COMPILE;
but only from executing it again
CREATE PROCEDURE etc...

Thanks in advance,
Best Regards,
Giovanni Received on Fri Dec 05 2003 - 12:29:44 CST