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

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

ALTER SESSION in system event trigger ?

From: Rosy <rolf.sydnes_at_gard.no>
Date: Fri, 22 Jun 2001 13:48:49 +0200
Message-ID: <9gvbdp$1vd$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:48:49 CDT












Original text of this message













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