Home -> Usenet -> c.d.o.server -> Re: How can I alter the parameter nls_sort

Re: How can I alter the parameter nls_sort

From: <fastbowler_at_gmail.com>
Date: Mon, 8 Dec 2014 05:52:43 -0800 (PST)
Message-ID: <549ee6da-777a-418b-a61d-7d5454f698fc_at_googlegroups.com> 






On Tuesday, June 24, 2008 3:40:36 AM UTC-4, gzja..._at_gmail.com wrote:


> On Jun 23, 8:37 pm, sybra..._at_hccnet.nl wrote:

> > On Mon, 23 Jun 2008 01:59:37 -0700 (PDT), gzjack..._at_gmail.com wrote:

> > >I used "alter system set nls_sort = binary_ci scope = spfile" to

> > >change the default value of the parameter nls_sort.Then I restarted

> > >the service of the database instance.I saw the instance value has

> > >changed.Now the problem is when I create a new connection the value of

> > >nls_sort was not binary_ci but binary.I don't know why the session

> > >value was not changed.

> >

> > >any advice will be appreciated!

> >

> > >Thanks a lot

> > >Jack.Lee

> >

> > Instance settings can be, and usually are, overridden by session

> > specific values.

> > Oracle always sends a series of alter session statements immediately

> > after logon.

> > Those can be changed by setting a registry string value in the correct

> > hive for Windows, or by setting an environment variable on Unix in

> > your .profile.

> > You can also use an execute immediate statement in an after logon

> > database trigger.

> >

> > Hth

> >

> > --

> > Sybrand Bakker

> > Senior Oracle DBA

> 

> I used an after logon trigger.It's done!

> 

> Thank u very much!


> Jack.Lee





Jack, Can you post the code for your trigger ? 
Thanks


-Sam
Received on Mon Dec 08 2014 - 14:52:43 CET












Original text of this message