Re: LONG to CLOB within a trigger - alternative to synching data values?
From: Jeremy <jeremy0505_at_gmail.com>
Date: Tue, 12 Jan 2010 09:28:11 -0000
Message-ID: <MPG.25b65109c24291099897c0_at_News.Individual.NET>
In article <925740be-b4ed-45b7-b6ea-
fabc72a5f5dd_at_c34g2000yqn.googlegroups.com>, Mark.Powell2_at_hp.com says...> I will gather that you have so all I can suggest is adding the CLOB
> column then performing an update process to populate the CLOBs. Once
> populated you could remove the long column or at least null it out.
>
Date: Tue, 12 Jan 2010 09:28:11 -0000
Message-ID: <MPG.25b65109c24291099897c0_at_News.Individual.NET>
In article <925740be-b4ed-45b7-b6ea-
fabc72a5f5dd_at_c34g2000yqn.googlegroups.com>, Mark.Powell2_at_hp.com says...> I will gather that you have so all I can suggest is adding the CLOB
> column then performing an update process to populate the CLOBs. Once
> populated you could remove the long column or at least null it out.
>
Thanks for the response, this is the conclusion I reached too. Shame.
-- jeremyReceived on Tue Jan 12 2010 - 03:28:11 CST