Return
-
Title
Toad schema browser generates bad sql when altering jb in "Sched.Jobs" -
Description
The following error occurs when altering a job in Schema Browser | Sched.Jobs by right clicking on a job and select "Disable Selected Job."
ORA-00929: missing period
ORA-06512: at "SYS.DBMS_UTILITY", line 132
ORA-06512: at "SYS.DBMS_UTILITY", line 164
ORA-06512: at "SYS.DBMS_UTILITY", line 218
ORA-06512: at "SYS.DBMS_SCHEDULER", line 1749
ORA-06512: at line 2
Details:
BEGIN
SYS.DBMS_SCHEDULER.DISABLE
(name => SINGTEL.Refresh Recommendation); END; Error at line 2
ORA-00929: missing period
ORA-06512: at "SYS.DBMS_UTILITY", line 132
ORA-06512: at "SYS.DBMS_UTILITY", line 164
ORA-06512: at "SYS.DBMS_UTILITY", line 218
ORA-06512: at "SYS.DBMS_SCHEDULER", line 1749
ORA-06512: at line 2
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.