Toad World® Forums

Toad for Oracle 12.12 bug reporting (job_name vs quotation marks)

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

Thanks. This will be fixed in the next beta.

Thanks…

Raul