Re: INSTEAD OF trigger problem.

Hi Harry,
if I read your code right you are trying to insert into the same object that you defined the trigger on. It has to be like this (pseudocode):

create trigger tr_name instead of insert on view begin
insert into table;
end.

Apolgies if I didn't catch it.

Greetings,
Guido

"Dean Harry" <dean_at_ganda.net.au> wrote...
> 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 - 13:01:37 CET