Re: PLS-00905: Object bankaccount is invalid
Date: 24 May 2003 21:05:07 -0700
Message-ID: <92eeeff0.0305242005.78885f4c_at_posting.google.com>
"Erwin" <erwincisco_at_yahoo.com.sg> wrote in message news:<%gBza.275$ES.2419_at_news-server.bigpond.net.au>...
> Hi,
>
> I just created a procedure an encountered the error message: PLS-00905:
> Object BANKACCOUNT is invalid.
> The error message doesn't point out something useful and normally this error
> occurs when IS/AS is missing in the procedure syntax, which is not in this
> case.
>
> Any comment on this?
>
> Thanks
"Object BANKACCOUNT is invalid". I don't know what more information do you want. Try to recompile BANKACCOUNT and use SHOW ERROR afterwards to get the error stack.
Which manual are you reading where it says that PLS-00905 normally means IS/AS is missing in procedure syntax??
"PLS-00905: An invalid package specification or stored subprogram was referenced. A package specification or stored subprogram is invalid if its source code or any database object it references has been DROPped, REPLACEd, or ALTERed since it was last compiled."
Regards
/Rauf Sarwar
Received on Sun May 25 2003 - 06:05:07 CEST