"Chris Blair" <chris_w_blair@ yahoo.com.uk.zz wrote in message news:<bhvk6a$mp f$1@nobel2.paci fic.net.sg>...
One should rather ask why anyone out of his right mind want to create
triggers on the fly using ODBC.
Shudder!
Sybrand Bakker
Senior Oracle DBA
Does anyone know how to use correlation names (:new and :old) through an
ODBC connection?
EG:
CREATE TRIGGER Print_Cust_chan ges
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...
ODBC connection?
EG:
CREATE TRIGGER Print_Cust_chan ges
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...
triggers on the fly using ODBC.
Shudder!
Sybrand Bakker
Senior Oracle DBA