Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Trigger referencing LONG in 8i

Trigger referencing LONG in 8i

From: Nicolai Tufar <ntufar_at_gmail.com>
Date: Tue, 8 Feb 2005 16:31:00 +0200
Message-ID: <d809293905020806316e543e6d@mail.gmail.com>


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-l
Received on Tue Feb 08 2005 - 09:39:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US