Re: ALTER SESSION in system event trigger ?

I found the following information on the error: PLS-00103 PLS-00103found 'str' but expected one of the following: 'str'

Cause:This message is from the parser. It found a token (language element) that is inappropriate in this context.

Action:Check previous tokens as well as the one given in the message. The line and column numbers given in the following message refer to the end of the faulty language construct.

"Philippe L. Balmanno" <plb2862_at_cts.com> wrote in message news:3b3657e9$0$769$e2e8da3_at_nntp.cts.com...
> 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:32:24 CEST