Re: ALTER SESSION in system event trigger ?
From: crappy <crappygolucky_at_hotmail.com>
Date: 25 Jun 2001 11:46:33 -0700
Message-ID: <ce31c410.0106251046.6e599525_at_posting.google.com>
Date: 25 Jun 2001 11:46:33 -0700
Message-ID: <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
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
-- execute alter session as 'dynamic' sql
execute immediate('alter session set NLS_DATE_LANGUAGE=FRENCH');
end;