Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: May procedures stops running for no reason!!! Please help

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

From: Robert Augustyn <robert.augustyn_at_unisys.com>
Date: 1998/10/22
Message-ID: <70nemi$dmt$1@mail.pl.unisys.com>#1/1

No,
It is not
thanks
robert
mpir_at_compuserve.com wrote in message <70n9gn$o2e$1_at_nnrp1.dejanews.com>...
>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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US