Re: ALTER SESSION in system event trigger ?

Something like this?

REM            *** Inserting a date into a report ***
SET              TERMOUT OFF
ALTER         SESSION SET NLS_DATE_FORMAT = 'DD-Mon-YYYY';
COLUMN    SYSDATE NEW_VALUE report_date
SELECT       SYSDATE FROM DUAL;
SET              TERMOUT ON

TTITLE        CENTER 'Data File Information' SKIP 2 -
                     LEFT 'Printed for ' FORMAT A20 SQL.USER -
                     CENTER 'On: ' report_date

"Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message news: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 - 23:11:59 CEST