Date: Fri, 09 Sep 1994 20:25:00 +0200
From: Arnold_Muenzer@hgs.fido.de (Arnold Muenzer)
Subject: long columns in triggers
Message-ID: <7e141a97@p21.f22.n5000.z242.fidonet.org>
Newsgroups: comp.databases.oracle
Organization: Fido.DE domain gateway (IN e.V.)
Lines: 7
X-Gateway: FIDOGATE 3.8.0BETA5
X-FTN-Tearline: GEcho 1.00
X-FTN-Origin: Arnold Muenzer (242:5000/22.21)
X-FTN-Domain: Z242@fidode
X-FTN-Seen-By: 1000/1 500 600 3000/1 4900/99 5000/0 8 10 20 6000/0 1 8000/0
X-FTN-Path: 5000/22 20 8 1000/1


It seems to be impossible to use long columns in a trigger
(in Oracle 7.0.x).
During an update I have to store some of the old table values in a history
table. For all other tables i am using the before update trigger, but it is
impossible for tables with LONG column.
Is there a workaround for this problem?