Re: May procedures stops running for no reason!!! Please help

In article <70lme7$qm6$1_at_mail.pl.unisys.com>,   "Robert Augustyn" <robert.augustyn_at_unisys.com> wrote

I haven't run into this, but as an idea, is it possible you have overlapping sessions where session 2 is locked out of something by session 1? You said that the program is run every few minutes.

> Hi,
> I have stored procedure which is activated every few minutes from Unix
> shell.
> It is a package and is relatively large( over 2200 lines of code )
> When I start it runs for several hours and then I get:
>
> ERROR at line 1:
> ORA-04045: errors during recompilation/revalidation of ARADMIN.CALL_ACTIONS
> ORA-00933: SQL command not properly ended
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
>
> and have to recompile the procedure and it runs again ok for a while
> any idea what would be the problem and how to trace it?
>
> Thanks in advance for your help
> robert
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 22 1998 - 00:00:00 CDT