Hi
I have no idea how to report a bug regarding Toad software. But I am just going to ask it here.
–The following procedure runs successfully, because I have quotation marks ("…") surrounding job_name
BEGIN
SYS.DBMS_SCHEDULER.RUN_JOB
(job_name => ‘<schema_name>."<job_name_in_lower_cases>"’
,use_current_session => FALSE);
END;
–The following procedure fails, because job_name_in_lower_cases is not surrounded with quotation marks…
BEGIN
SYS.DBMS_SCHEDULER.RUN_JOB
(job_name => ‘<schema_name>.<job_name_in_lower_cases>’
,use_current_session => FALSE);
END;
–The error is following:
–ORA-27475: “<schema_name>.<job_name_in_lower_cases>” must be a job
–ORA-06512: at “SYS.DBMS_ISCHED”, line 196
–ORA-06512: at “SYS.DBMS_SCHEDULER”, line 486
The thing is, when I have job_name in lower cases, and I run a job from schema browser view Sched. jobs (right click to job_name and Run Job), then I get this error that is mentioned above, because Toad does not surround job_name with quotation marks.
You can test this, by creating a job, where job_name is in lower cases and job_name must be surrounded with quotation marks, then oracle saves the job_name to a dictionary also with lower cases.
Toad for Oracle 12.12.0.39
Regards
Raul