Re: ALTER SESSION in system event trigger ?

The 'execute immediate' worked just fine.

The reason I want to do this is to ensure that users connecting to 'my' database have NLS session parameters set right, no matter how their client is set up. (NLS envirinment variables on the client will override the servers init.ora settings !?)

Rolf

"crappy" <crappygolucky_at_hotmail.com> wrote in message news:ce31c410.0106251046.6e599525_at_posting.google.com...
> i think the problem is using ALTER in a PL/SQL block (which the
> trigger body is, of course). i suppose you can do a something like
>
> create or replace trigger blahtrg after logon on database
> begin
> -- execute alter session as 'dynamic' sql
> execute immediate('alter session set NLS_DATE_LANGUAGE=FRENCH');
> end;
>
> but this seems like a hack to me. is there a reason you can't set it
> as a parameter in the database's init.ora (see Oracle8i National
> Language Support Guide)?
Received on Wed Jun 27 2001 - 15:17:09 CEST