RE: Getting a Clob into a Long

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <bonnergj@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 18 Oct 2004 18:16:28 -0400

Gary,

Sorry to say, I think you're looking at implementing a Pro*C solution.

I know it can be done via Pro*C.  I don't think you'll find any
direct SQL or PL/SQL solution.

-Mark

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
bonnergj@xxxxxxxxxxxxx
Sent: Monday, October 18, 2004 5:44 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Getting a Clob into a Long






I have a bit of a dilemma here.  We have a production table that has a =
long
datatype on it and for reasons
I won't get into cannot be converted to a clob for several more months.
I have a work table that has a clob on it as one of the columns. I need =
to
copy the row from the clob table into the table with the long.
This is all done in a stored procedure that gets called when needed. I =
go
through a loop that parses the
clob into varchar2 chunks and then concatenates them into a plsql long
datatype. Problem is a plsql long
datatype can only be 32k. Some of the clobs are longer and thus the
problem.
There are built-in functions to convert/load from a long to a clob  but =
I
haven't been able to find a way of going the other way.
Longs on tables can hold 2gig but a plsql long can only handle 32k.
Does anyone out there have any ideas how I could do this?
I have tried every possible scenario I can think of with no success.
Thanks for listening, Gary

--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: