Re: The pseudo-records :NEW.

Hi Oscar,
You can't use :new as a record, you need to refer to individual columns. :new will work both before and after insert. Because this is your first post, you are advised to specify your database version and O/S always.
You are also advised to 'ask' or 'request', not to demand. After all this replying in this newsgroup is volunteer work (with the exception probably of Thomas Kyte and Pete Sharman) and many people do this in their spare free time.

Hth,

--
Sybrand Bakker, Oracle DBA

Oscar Martinez <oscarm_at_sicon.net> wrote in message news:7rl6kq$r9m$1_at_talia.mad.ttd.net...
> Hi, I new in this newsgroup, and this is my first question. This is the
> question:
>
> I can use the pseudo-record :NEW in a database trigger After or Before
> Insert in the table?.
>
> I'm using this pseudo-record and I don't anything and occurs an error:
>
> ORACLE error: unable to INSERT record.
>
> I have all privileges in a database and I don't any Insert Into in the
> trigger.
>
>
> I need a solution, quickly.
>
> Thanks in advance, Oscar...
>
>
>
>
Received on Tue Sep 14 1999 - 13:59:29 CDT