Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB.RUN - requires spare job queue slot?
"Jeremy" <newspostings_at_hazelweb.co.uk> wrote in message
news:MPG.1d18a8f9bb0bdbd7989eba_at_news.individual.net...
> In article <d8m4o8$82$1_at_news.caravan.ru>, Dmitry E. Loginov says...
> > Be noticed: DBMS_JOB.RUN will reset state of packages in your session.
>
> Not clear what you mean by this. You don't mean like variable values set
> immediately before calling DBMS_JOB.RUN will be reset to their default
> values in the calling PL/SQL upon completion of the JOB do you?
Yes. DBMS_JOB.RUN reinitializes all packages in the current session.
> Or are you saying that if DBMS_JOB.RUN is used to execute a procedure in
the
> same package as the calling PL/SQL then its state will be reset?
>
> Or perhaps it is time to go read up some more on this ;)
>
> --
>
> jeremy
Received on Tue Jun 14 2005 - 08:15:36 CDT