Re: ALTER SESSION in a system event trigger?

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

You likely need to do this as Native Dynamic SQL.

Daniel A. Morgan Received on Fri Jun 22 2001 - 10:10:59 CDT