Use DBMS_SCHEDULER to replace DBMS_JOB

DBMS_JOB has been around forever, and now it is deprecated. Although DBMS_JOB still exists in 10g and 11g, but only for backward compatibility. No new features are being added to dbms_job and you will likely quickly run into its limitations. Oracle recommends the use of DBMS_SCHEDULER in releases 10g and up. DBMS_SCHEDULER is a much [...]

ORA-06553: PLS-801: internal error [56319]

When i have finish update oracle 32-bit to 64-bit, then i try to compile procs and I got this message, Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-06553: PLS-801: internal error [56319] ————————————————— ORA-00604: error occurred at recursive SQL level 2 ORA-06544: PL/SQL: internal error, arguments: [56319],[], [], [], [], [], [],[] ORA-06553: PLS-801: internal error [56319] i have tried steps to fix this problem - run STANDARD.SQL to reinstall [...]

Oracle DBMS_JOB

· Introduction The DBMS_JOB package is known as the job queue. The Oracle job queue provides programs for submitting and executing jobs, changing job execution parameters, and removing or temporarily suspending job execution at predefined times and/or repeated job execution at regular intervals. Users on Oracle 10g and above should use the newer DBMS_SCHEDULER package. [...]

Follow

Get every new post delivered to your Inbox.