Oracle case sensitivity

[#1]

My application (WizSource Source Control) comes in PB10 and PB10.5 versions and is designed to work with various databases.

I have come across a problem with Oracle which appears to be caused by queries being case sensitive.

I am pretty sure there is a session command I can use to change it to case insensitive but what exactly the command is, I don't know.

I would appreciate it if an Oracle guru could give an example.

Thanks,

Roland

[Former Member]

Hi Roland;

  Many DBMS's - not just Oracle - can be installed with or without case sensitivity. Normally, the DBA can change that on the DBMS server for either the server or the individual database (depending on the vendor).

AFAIK: There is no way in PL/SQL to change this at run-time.  

Regards ... Chris