Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Trigger referencing LONG in 8i
Greetings,
We have a legacy application using 8i database which we have to replicate using insert triggers. One of the tables includes LONG column, when we try to create a trigger it fails immediately with "ORA-04093: references to columns of type LONG are not allowed in triggers" error message.
We can not upgrade database or change the column type. Does anyone have experience dealing with triggers on tables including LONG column? What can be done in this situation?
Thanks in advance,
Nicolai Tufar
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 08 2005 - 09:39:29 CST