Oracle Trigger problem after SQL Server conversion via Oracle Workbench...
Posted on 2006-05-17
This is the result of a trigger from the conversion:
CREATE OR REPLACE TRIGGER TR_S_322_1_T_SECURITY
BEFORE INSERT ON T_SECURITY
FOR EACH ROW
Of course this fails now, which it did not in the SQL Server instance. We are in the middle of an upgrade from SQL 2k to Oracle 10G and this is the last of the many problems we have encountered...A bit stumped on this.
The above query works just fine.....?
Any help would be greatly appreciated.