Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Why does a job loose its context?
Dear list,
we have some PL/SQL procesdures that submit jobs to our 8i database. And we have a logon trigger that sets an application context like this:
dbms_session.set_context('BENUTZER', 'BENUTZ_ID', v_benutz_id);
While running the job, this context information can be retrieved with SYS_CONTEXT(). That worked well for years. But lately we sometimes observe that SYS_CONTEXT() retrieves no data.
We found out, that with prestarting a scheduled job with TOAD's execute button the context information gets lost too. But we don't do that on production where we see that sometimes at night.
Does Oracle on its own do something like a rescheduling that is cleaning up the context of a job?
Greetings, Peter
![]() |
![]() |