Re: NLS_COMP=ANSI and NLS_SORT=GENERIC_BASELETTER

Kalle

The location of these settings will depend on your environment, if all sorts etc for the whole database are to use these settings the alter system commend can be used to make a global change:

ALTER SYSTEM SET NLS_SORT=GENERIC_BASELETTER; If the change is for part of the database, an alter session command can be used

ALTER SESSION SET NLS_SORT=GENERIC_BASELETTER; In a program, package or procedure this is best issued via execute immediate, shown here in an annonamous block:

BEGIN EXECUTE immediate 'ALTER SESSION SET NLS_SORT=GENERIC_BASELETTER'; EXECUTE immediate 'ALTER SESSION SET NLS_COMP=ANSI';

• your code

END; After 'your code' you could then revert to the origional settings, again using ALTER SESSION. A more generic solution would be to wrap the commands in a package and then call a procedure in the pacakge to make the change, let me know if you want an examle of this.

Regards

Graham

"Kalle" <kminerva_at_jippii.fi> wrote in message news:3E603E1D.C54B8A8F_at_jippii.fi...
> Hi,
>
> I need to do some sorts with Scandinavian characters and I need to set
> these parameters
>
> NLS_COMP=ANSI and
>
> NLS_SORT=GENERIC_BASELETTER
>
> Where do I put these because I am using and application and WebLogic is
> calling some programns which are actually using that sorts...
>
> Any ideas would be apreciated...
>
> TIA
> Kalle
>
Received on Sat Mar 01 2003 - 02:42:54 CST