8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for DBMS_JOB Jobs Converted to DBMS_SCHEDULER Jobs in Oracle Database 19c

Tobi said...

We ran into another problem today:

We used
dbms_job.submit(myjobid, 'myprocedure( JOB );');
in one of our 12.2 DBs. Everything works fine.
After updating this DB from 12.2 to 19.7 the value that we pass via JOB to myprocedure is no longer the same as myjobid.
We already found a workaround, but maybe this helps somebody else.

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.