The answer is in the error. You can't.
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Christian Hartmann" <c.hartmann_at_tmp-office.de> wrote in message
news:8ivvfe$5rg9u$1_at_fu-berlin.de...
> 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
