ODBC & Correlation Name (:new and :old)
From: Chris Blair <chris_w_blair_at_yahoo.com.uk.zz>
Date: Wed, 20 Aug 2003 18:59:42 +0800
Message-ID: <bhvk6a$mpf$1_at_nobel2.pacific.net.sg>
Date: Wed, 20 Aug 2003 18:59:42 +0800
Message-ID: <bhvk6a$mpf$1_at_nobel2.pacific.net.sg>
Does anyone know how to use correlation names (:new and :old) through an
ODBC connection?
EG:
CREATE TRIGGER Print_Cust_changes
BEFORE INSERT ON CUST_tab
FOR EACH ROW
BEGIN
dbms_output.put('Adding: ' || :new.custid);
END;
When I try to do that using ODBC, I get this error:
Server Msg: 24344, State: HY000, [Oracle][ODBC][Ora]
Trigger, procedure or function created with PL/SQL compilation error(s).
And if I try and Insert I get:
Server Msg: 4098, State: HY000, [Oracle][ODBC][Ora]
ORA-04098: trigger 'BCL.PRINT_CUST_CHANGES' is invalid and failed
re-validation
Of course the same code works perfectly in SQL*Plus... Received on Wed Aug 20 2003 - 12:59:42 CEST