Print Thread
DBMS_Scheduler UI does not preserve case
#47916 09/29/13 11:35 PM
Joined: Feb 2013
Posts: 251
UTC+10
I
IvanZ Offline OP
Member
OP Offline
Member
I
Joined: Feb 2013
Posts: 251
UTC+10
Hello,

now I shall explain the subject:

If you create a job with a case sensitive name, for ex. HR."RegularTask"

DBMS_Scheduler will show it's name corecly, but when you try to change something, for ex Disable the Job, the UI will generate the following SQL:
begin
sys.dbms_scheduler.disable(name => 'HR."REGULAR_TASK"');
end;

This sql will obviously fail.

It seems to me that UI uppercase every object name when generating SQL, wich is not correct.

Could you please fix this.


Re: DBMS_Scheduler UI does not preserve case
IvanZ #47918 09/30/13 10:00 AM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
We'll check it out.


Marco Kalter
Allround Automations
Re: DBMS_Scheduler UI does not preserve case
Marco Kalter #47968 10/09/13 03:25 AM
Joined: Feb 2013
Posts: 251
UTC+10
I
IvanZ Offline OP
Member
OP Offline
Member
I
Joined: Feb 2013
Posts: 251
UTC+10
Any news on this?

Re: DBMS_Scheduler UI does not preserve case
IvanZ #47970 10/09/13 08:51 AM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
Yes, we'll have a fix available shortly.


Marco Kalter
Allround Automations
Re: DBMS_Scheduler UI does not preserve case
Marco Kalter #50006 01/08/15 05:09 AM
Joined: Feb 2013
Posts: 251
UTC+10
I
IvanZ Offline OP
Member
OP Offline
Member
I
Joined: Feb 2013
Posts: 251
UTC+10
Still not fixed in 11b1 =((


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.023s Queries: 14 (0.008s) Memory: 2.5155 MB (Peak: 3.0427 MB) Data Comp: Off Server Time: 2024-05-20 14:28:54 UTC
Valid HTML 5 and Valid CSS