INSTEAD OF trigger problem.
From: Dean Harry <dean_at_ganda.net.au>
Date: Thu, 09 Jan 2003 03:17:42 GMT
Message-ID: <qR5T9.16628$oS1.65863_at_news-server.bigpond.net.au>
Date: Thu, 09 Jan 2003 03:17:42 GMT
Message-ID: <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'.