ORA-01036

por Anónimo | 12/04/2007 15:40:43

RE: ORA-01036

envio mi sintaxis porque no se que estoy haciendo mal... gracias

CREATE OR REPLACE TRIGGER AR.REFERENCIA_FACTURA
AFTER
INSERT OR UPDATE OF CUSTOMER_TRX_ID, INTERFACE_HEADER_ATTRIBUTE1
ON AR.RA_CUSTOMER_TRX_ALL
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW

declare
cursor Prueba is
select INTERFACE_HEADER_ATTRIBUTE1,CUSTOMER_TRX_ID
from RA_CUSTOMER_TRX_ALL
where CUSTOMER_TRX_ID = :new.CUSTOMER_TRX_ID and
INTERFACE_HEADER_ATTRIBUTE1 = :new.CUSTOMER_TRX_ID;