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: Alen Cappelletti <alen.cappelletti_at_gmail.com>
Date: Mon, 02 Jul 2007 08:27:29 -0000
Message-ID: <1183364849.779535.189740@g4g2000hsf.googlegroups.com>


On Jul 2, 10:05 am, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> 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 tohttp://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_...
> you can access the column values (:NEW,:OLD) only in row trigger.
>
> Best regards
>
> Maxim

OK Maxim, I think understand my error...I write then after "new.privato = 1"



FOR EACH ROW
WHEN (new.privato = 1)

Thanks Received on Mon Jul 02 2007 - 03:27:29 CDT

Original text of this message

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