How to fix the Oracle error ORA-04093: references to columns of type LONG are not allowed in triggers?

In this post, you’ll learn more about the Oracle ErrorORA-04093: references to columns of type LONG are not allowed in triggers with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-04093: references to columns of type LONG are not allowed in triggers

A trigger attempted to reference a long column in the triggering table.

How to fix the Error ORA-04093: references to columns of type LONG are not allowed in triggers ?

You can fix this error in Oracle by following the below steps

Do not reference the long column.