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

do u have a dynamic sql statements in there? if u do, try to check if they are ok.
i used to get this error just because i was using dynamic sql and passing in a values the wrong way.

for example
  select * from my_table where name = bob  select * from my_table where name='bob'

Robert Augustyn wrote:

> 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 Fri Oct 23 1998 - 00:00:00 CEST