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 -> Re: trigger syntax for after insert

Re: trigger syntax for after insert

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 02 Jul 2007 10:05:02 +0200
Message-ID: <4688B1AE.8050400@gmail.com> 





Alen Cappelletti schrieb:


> Cause when I compile a got an error...




And you suppose, providing the exact error message/number would make the 
life too easy for folks here?



Just in case, this is an ORA-04082, then according to
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_triggers.htm#i1006211
you can access the column values (:NEW,:OLD) only in row trigger.



Best regards



Maxim
Received on Mon Jul 02 2007 - 03:05:02 CDT












Original text of this message













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