I’m fond of launching spotlight from Toad for Oracle under monitor session browser. The first 2 database connections worked perfectly. The second and third give me this error.
The Spotlight User Wizard has encountered an error. An error was reported for table “CreateATPkgBody” in connection “DRSD0.USPS.GOV”.
The error is:
ORA-24344: success with compilation error
2658/10 PLS-00201: identifier ‘DBMS_JOB.SUBMIT’ must be declared
2658/10 PL/SQL: Statement ignored
in table createATPkgBody
Any ideas on how to get around this? It doesn’t make sense that it works in some and not others. The databases are installed the same and they are the same version.