Re: Long columns obsolete

From: Burt Peltier <burttemp1ReMoVeThIs_at_bellsouth.net>
Date: Sat, 6 Dec 2003 16:15:53 -0600
Message-ID: <exsAb.3583$nH.3116@bignews6.bellsouth.net>

Ok... I may be wrong, but I just recently did a lot of testing of the limits of varchar2 and could have sworn that when passing an argument with 4001 characters for a varchar2, I got some kind of error in the call... the PlSql code was never even envoked I think.

I was looking for a way to pass more than 4000 characters .. not more than 32K .

So, are you saying it is ok to store in memory, but just cannot pass it around (between PlSql units) or store in a table(obviously) ?

-- 
"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
news:uxqAb.67846$kl6.27472_at_fed1read03...


> Burt Peltier wrote:

> > I wish Oracle would either expand varchar2 or provide another datatype

> > SOMEWHERE (just 32K would be ok) between 4GIG and 4K :)

> FWIW - VARCHAR2 variables in PL/SQL can hold 32,000 bytes or so.

> The "4K" limitation is what can be stored in a column of a table.

>

Received on Sat Dec 06 2003 - 16:15:53 CST