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

From: Robert Augustyn <robert.augustyn_at_unisys.com>
Date: 1998/10/21
Message-ID: <70lme7$qm6$1_at_mail.pl.unisys.com>#1/1

Hi,
[Quoted] 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:

[Quoted] ERROR at line 1:

ORA-04045: errors during recompilation/revalidation of ARADMIN.CALL_ACTIONS
[Quoted] [Quoted] ORA-00933: SQL command not properly ended
[Quoted] [Quoted] 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 Received on Wed Oct 21 1998 - 00:00:00 CEST

This message: [ Message body ]
Next message: Dennis Chebotarev: "Designer 2.1 (Tables in different schemas)"
Previous message: David Lai: "Re: Oracle to Sybase replication"
Next in thread: Dennis: "Re: Help: dynamic sql"
Reply: mpir_at_compuserve.com: "Re: May procedures stops running for no reason!!! Please help"
Reply: Tommy Wareing: "Re: May procedures stops running for no reason!!! Please help"
Reply: Dennis: "Re: Help: dynamic sql"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message