Re: ALTER SESSION in system event trigger ?
From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Sun, 24 Jun 2001 04:08:04 GMT
Message-ID: <3B356A3F.22E9BF76_at_telusplanet.net>
Date: Sun, 24 Jun 2001 04:08:04 GMT
Message-ID: <3B356A3F.22E9BF76_at_telusplanet.net>
I believe that all valid settings are listed in the SQL Language (not SQL*Plus)
refernce manual, available at http://technet.oracle.com > Documentation >
Oracle8i and Oracle JVM link. Your question should be answered there.
/Hans
Rosy wrote:
> I'm trying to do a 'ALTER SESSION SET NLS_DATE_LANGUAGE=.....' in an 'AFTER
> LOGON ON DATABASE' system event trigger . Gets error PLS-00103 from the
> parser ('..found ALTER but expected one of the following:....').
> Is this operation illegal in triggers on system events?
>
> Any help would be appreciated.
>
> Rolf
Received on Sun Jun 24 2001 - 06:08:04 CEST