Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Page 1000 serial(JOB) #1

Open
kprzep opened this issue Apr 18, 2022 · 2 comments
Open

Page 1000 serial(JOB) #1

kprzep opened this issue Apr 18, 2022 · 2 comments

Comments

@kprzep
Copy link

kprzep commented Apr 18, 2022

When I run the code from page 1000, then the submited jobs returns errors like this:
ORA-01403: no data found
ORA-06512: at "MYUSER.SERIAL", line 5
ORA-06512: at line 1

It is because the line which calls serial() procedure:
dbms_job.submit( l_job, 'serial(JOB);' );
uses name: JOB which doesn't provide the job number.
Could you correct the code of this anonymous block and/or serial procedure to run the code successfully?
Regards
KP

@kprzep
Copy link
Author

kprzep commented Apr 18, 2022

This happens, because JOB doesn't store: sys.scheduler$_dbmsjob_map.DBMS_JOB_NUMBER
but it stores: SYS.scheduler$_job.obj#
KP

@kprzep
Copy link
Author

kprzep commented Apr 18, 2022

OK, the problem is in 19.3 and solved in 19.12 onwards:
https://connor-mcdonald.com/2020/09/03/dbms_job-and-19c-code-changes-needed/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant