There can be many reasons for a stored proc to become invalid. Is
development on the sp's ongoing? If so, every time a procedure or function
which is called by your stored proc is recompiled your procedure will become
invalid. Long shot, but worth checking.
Rob
> -----Original Message-----
> From: Dwidesh E.V. [SMTP:[EMAIL PROTECTED]]
> Sent: 08 July 1999 07:00
> To: [EMAIL PROTECTED]
> Subject: PFCSIG nonPFC question
>
> hi all,
>
> sorry for non-PFC question being posted.
> we face a strange problem of oracle procedure becoming invalid. we are
> using
> oracle 7.3 and PB6.0. we found that sometimes the oracle proc. become
> invalid
> after running within same session twice or more. Note that we are calling
> stored proc. through RPC.
>
> could some one help us out, what are possible causes of becoming proc.
> invalid. There is no DLL statment being executed, which is one primary
> cause.
>
> can some one shed other causes of it.
>
> any help in this regard is appreciated.
>
> regards,
> dwidesh
>
> ____________________________________________________________________
> Get free e-mail and a permanent address at http://www.netaddress.com/?N=1
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
> ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
> pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
