Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> ALTER SESSION in a system event trigger?

ALTER SESSION in a system event trigger?

From: Rosy <rolf.sydnes_at_gard.no>
Date: Fri, 22 Jun 2001 13:44:53 +0200
Message-ID: <9gvb6d$lk$1@oslo-nntp.eunet.no> 






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 Fri Jun 22 2001 - 06:44:53 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US