Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL-SQL & strings larger than 32K

PL-SQL & strings larger than 32K

From: Anil Kamath <akk_16_at_yahoo.com>
Date: Sat, 25 Sep 1999 08:42:08 GMT
Message-ID: <7si1sv$ilg$1@nnrp1.deja.com> 







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





--




Anil Kamath


SmartOnline Inc. (www.smartonline.com)




Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Sat Sep 25 1999 - 03:42:08 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US