Re: LONG to CLOB within a trigger - alternative to synching data values?

From: Jeremy <>
Date: Fri, 8 Jan 2010 14:51:22 -0000
Message-ID: <MPG.25b156c96fd510b79897be_at_News.Individual.NET>

In article <566ef7e9-c38c-43a2-8e12-29c006559181>, says...

> I have never tried to perform Long to CLOB conversion in a trigger but
> it should be possible.
> Use "DBMS_LOB.Copy() function can copy all or part of a source
> internal CLOB to a
> CLOB or BLOB to a BLOB."
> Quote from Oracle support document: How to convert LONG to a CLOB
> #ID 282464.1

Will this not run into the same issue when referring to :new.oldlongcolumn?

Received on Fri Jan 08 2010 - 08:51:22 CST

Original text of this message