Re: PLS-00905 error

The message means proc2 didn't compile.
If you want to do it this way, you need to make sure the procedure proc2 *will* compile before issuing the compile command. Just to be sure, yesterday I advised you were forced to do everything dynamically in the rest of your program. In that case there would have been no need to recompile proc2.

Regards,

Sybrand Bakker, Oracle DBA

"Gennady" <gennadyb_at_halcosoftware.com> wrote in message news:394a6330$0$2939_at_fountain.mindlink.net...
> Hello,
> I try to run PL/SQL code:
> declare
> .....
> begin
> .....
> Proc1;
> ........
> Proc2;
> ...........
> end;
> The Proc1 create objects ( tables) , which Proc2 will use.
> Also Proc1 contains expression : alter procedure Proc2 compile.
> But when I run the code I receive the error PLS-00905:object Proc2 is
> invalid.
> How can I fix the problem?
> Thanks,
> Gennady
>
>
>
Received on Fri Jun 16 2000 - 00:00:00 CDT