Re: Problem with PL/SQL code

From: Marc Fleischeuers <Marc.Fleischeuers_at_kub.no-spam.nl>
Date: 1998/03/06
Message-ID: <uhg5cb6aj.fsf@kub.nl>#1/1

Gillian Murugappan <gmuruga_at_entergy.com> writes:

> Following is the code I am trying to execute, but something is
> wrong. Could someone help with the syntax??
>
> CREATE TRIGGER oraap.ap_invoice_ad
> AFTER DELETE ON ap.ap_invoices
> FOR EACH ROW
> REFERENCING OLD AS ap.ap_invoices
> NEW AS oraap.ap_invoice_audit

                     ^^^ OLD and NEW should be used to refer to column

names, you appear to use table names here. You could leave out the entire REFERENCING clause.

Marc Received on Fri Mar 06 1998 - 00:00:00 CST