LOB in Trigger

From: Christian Hartmann <c.hartmann_at_tmp-office.de>
Date: 2000/06/23
Message-ID: <8ivvfe$5rg9u$1@fu-berlin.de>#1/1

Hi there,

on oracle 8i using a trigger (update) I want to pass the value of a long-field to a stored procedure (:NEW.Long_Field_Name). Unfortunately, I got the error-message:

ORA-04093 references to columns of type LONG are not allowed in triggers Cause:

A trigger attempted to reference a LONG column in the triggering table.
Action:

Do not reference the LONG column.

In this long-field there are only ascii-values. It is used as a remark field.

Is there a way , to use the value of this long-field in a trigger? If yes, how?

Thanx for help,

Christian Hartmann Received on Fri Jun 23 2000 - 00:00:00 CDT