Pop-up list or dot lookup when typing dbms_job. does not appear in SQL Navigator for Oracle 6.0. Itbehaves differently on pop list for dbms_job. entry.
In the SQL Editor for SQL Navigator for Oracle 5.5, typedbms_job.and there will be pop list or dot lookup for .submit(job,what,next_date,interval,no_parse,instance,force);
RESOLUTION 1:
1. Go to View | Preferences in the main menu.
2. In the Preferences window go to Code Editor | General.
3. Scroll down and make sure the option Automatic Code Completion & Dot Lookup is checked.
NOTE: If already checked, un-check it, click OK and close SQL Navigator. Re-launch SQL Navigator and re-check it.
4. Click on Apply and OK.
RESOLUTION 2:
Typedbms_job.submit(on the editor for SQL Navigator for Oracle 6.0 and it will include the same parameters as SQL Navigator for Oracle 6.0.
Here is the sample:
dbms_job.submit(JOB=>?, WHAT=>?, NEXT_DATE=>?, INTERVAL=>?, NO_PARSE=>?, INSTANCE=>?, FORCE=>?)
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center