Trigger referencing LONG in 8i

  • From: Nicolai Tufar <ntufar@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 8 Feb 2005 16:31:00 +0200

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
--
//www.freelists.org/webpage/oracle-l

Other related posts: