Case sensitivity

[PdS]

Hello!

I now working on project where case-sensitive names of tables, fields and some triggers used "by-design" and migrated from previous version of application. I know - it's rare choice, but it's a big trouble for me that PL/SQL Developer wan't support this names correctly at all.

May be some settings i miss?

Any chance to support will be added at nearest time?

Any known workarounds about topic?

Unfortunately, for this time I found only one heuristic to enclose identifiers into double quotes, based on representation of object name in views such all_tables (all letters capitalized or not).
But, nevertheless, I hope, that this function will appear in the nearest versions.

--

Example code, based on my troubles
Such code autogenerated, and can't be changed

create table "MY_CaseTest" (
"KeyField" number(10),
"Field_Ref2" number(10),
field_val varchar2(1024)
)
/
create sequence "MY_CaseTest$T"
/
create or replace trigger "MY_CaseTest$$$StdTg"
before insert or update on "MY_CaseTest" for each row
begin
ifnew."KeyField" is null) then
select "MY_CaseTest$T".NextVal into :new."KeyField" from dual;
end if;
end;
/

Developer wan't drop this objects, recompile, generate proper DDL, open trigger for editing and do some other things.

It's only trouble for me in PL/SQL Developer for now, all other things works perfect. Big thanks to developers of Developer!

 

[Marco Kalter]

There are indeed some restrictions when using mixed case identifiers. We'll fix this in a future release.

 

[Marco Kalter]

There are indeed some restrictions when using mixed case identifiers. We'll fix this in a future release.

 

[PdS]

Thanks for comments.
Where I can get list of such restrictions(FAQ, help, other sources)?
Or it's totally wan't work?

When release with fixes will be available(estimated)? My plans depends on availability of this functionality of PL/SQL Developer (wait for it or develop my own DDL and data import/export).

Thanks in advise.