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: sybrandb <sybrandb_at_gmail.com>
Date: Mon, 02 Jul 2007 01:29:43 -0700
Message-ID: <1183364983.200131.295500@w5g2000hsg.googlegroups.com>


On Jul 2, 10:24 am, Alen Cappelletti <alen.cappelle..._at_gmail.com> wrote:
> 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
>
> naturally...but I'm not on my production PC until this evening....
> simple, Is syntax trigger correct?
> THANKS
Please don't misuse this forum for having people do *YOUR* work for free.

Thank you

--
Sybrand Bakker
Senior Oracle DBA
Received on Mon Jul 02 2007 - 03:29:43 CDT

Original text of this message

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