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