Re: LONG to CLOB within a trigger - alternative to synching data values?
From: Jeremy <jeremy0505_at_gmail.com>
Date: Fri, 8 Jan 2010 14:51:22 -0000
Message-ID: <MPG.25b156c96fd510b79897be_at_News.Individual.NET>
In article <566ef7e9-c38c-43a2-8e12-29c006559181 _at_j19g2000yqk.googlegroups.com>, Mark.Powell2_at_hp.com says...
Date: Fri, 8 Jan 2010 14:51:22 -0000
Message-ID: <MPG.25b156c96fd510b79897be_at_News.Individual.NET>
In article <566ef7e9-c38c-43a2-8e12-29c006559181 _at_j19g2000yqk.googlegroups.com>, Mark.Powell2_at_hp.com 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?
-- jeremyReceived on Fri Jan 08 2010 - 08:51:22 CST