getting job number of queued job

Is there a way for a procedure running in the job queue to obtain it's job number from the ORACLE environment, instead of having to pass it in as a parameter.

Using the dbms_job package, the job parameter must be part of the parameter list on the submit, e.g.

dbms_job.submit(job_number, p1(job),...);

Instead of passing the job parameter, can p1 figure out it's job number from some environmental call - NOTE - I could check in the user_jobs table but if there are more than one instances of P1, I'm stuck.

Could you e-mail me at ParrisG_at_aol.com

Thanks
Parris Received on Wed Mar 11 1998 - 00:00:00 CST