Are there any issues with the use of deleted and inserted pseudo columns from Microsoft SQL Server?
The parser in the Microsoft SQL Server 7.0 plug-in incorrectly converts Microsoft SQL Server T-SQL stored procedures that contain the following: SELECT @one=COL1, @two=COL2 FROM DELETED The parser converts stored procedures to the following in PL/SQL: SELECT :OLD.COL1, :OLD.COL2 INTO one, two FROM DUAL; SELECT @one=COL1, @two=COL2 FROM DELETED, fred SELECT COL1, COL2 INTO one, two FROM fred; StoO_rowcnt := SQL%ROWCOUNT; You must manually correct PL/SQL stored procedures that are converted in this way. Rewrite the code as follows: SELECT :OLD.COL1, :OLD.COL2 INTO one, two FROM fred; StoO_rowcnt := SQL%ROWCOUNT; See Also: For more information, see “Parsing”.
