Re: PL-SQL & strings larger than 32K

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 25 Sep 1999 09:13:52 -0400
Message-ID: <WMrsN=PderZiLVBS=NUoyXYab2uE@4ax.com>

A copy of this was sent to Anil Kamath <akk_16_at_yahoo.com> (if that email address didn't require changing) On Sat, 25 Sep 1999 08:42:08 GMT, you wrote:

>
>
>I have 100+ char strings that I have to concatenate
>and then store in a LONG database column..I am
>using PL-SQL scripts to do this. Since the limit
>for varchar2 and long datatype in PL-SQL is 32K,
>if my combined concatenated string (PL_SQL variable)
>goes about 32K i get a numeric or value error..
>
>Any ideas to implement this
>
>-anil

there is no way to insert/update a LONG or LONG RAW column that is greater then 32k using PLSQL.

PLSQL can piecewise READ but not WRITE a LONG column.

Can you use a CLOB instead -- plsql has piecewise access (read and write) to clobs.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Sep 25 1999 - 08:13:52 CDT