Re: Have keep recompiling procedure

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 23 May 2001 22:08:28 -0700
Message-ID: <3B0C974B.6A77BCF6@exesolutions.com>

jimbo wrote:

> Hello,
>
> I have a script that runs every few hours and calls 3 stored
> procedures.
> Periodically it fails with this message:
>
> ORA-06553: PLS-707: unsupported construct or internal error [2601]
> ORA-06550
>
> and I have to recompile. Then it runs fine. No other objects have
> been changed. It's a simple proc. This happens in both a test and
> production schema. This seems to happen even if it's not run; somehow
> it gets reset, although it's still marked as valid. We're thinking
> (for lack of any other ideas) that a nightly back-up has something to
> do with it.
>
> Any ideas?

I'm thinking that we need to see it to really provide any useful help.

Daniel A. Morgan Received on Thu May 24 2001 - 00:08:28 CDT