Re: INSTEAD OF trigger problem.

The entire post looks bad to me. I would not use "INSERT INTO V_CUSTOMER" for a trigger name. Is "CUSTOMER" a view built on top of table CUSTOMER? If yes, it is another bad idea. You have a typo here:

INSET INTO CUSTOMER To avoid any confusion, I would suggest that you cut and paste your entire table, view, trigger definition as well as the error messages as seen from SQL*PLUS when an insert statement is run.

• Jusung Yang

"Dean Harry" <dean_at_ganda.net.au> wrote in message news:<qR5T9.16628$oS1.65863_at_news-server.bigpond.net.au>...
> Hi All,
>
> I am having a problem with an INSTEAD OF trigger.
>
> I have a pretty basic trigger:
>
> CREATE OR REPLACE TRIGGER "INSERT INTO V_CUSTOMER" INSTEAD OF INSERT ON
> "CUSTOMER"
> BEGIN
> INSET INTO CUSTOMER
> (CUST_CODE)
> VALUES (:NEW.CUST_CODE);
> END;
>
> When this trigger fires I get the error 'unsupported feature with RETURNING
> clause'.
>
> I am using Oracle 8.1.3...
>
> Any help would be great!
>
> Regards,
> Dean Harry
> dean_at_callit.com.au
Received on Thu Jan 09 2003 - 09:02:11 CET