ORA-01036
Error: ORA-01036: illegal variable name/number
Causa: Unable to find bind context on user side.
Acción: Make sure that the variable being bound is in the SQL statement.
COMENTARIOS:
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;