Re: Long columns obsolete

From: Burt Peltier <burttemp1ReMoVeThIs_at_bellsouth.net>
Date: Sat, 6 Dec 2003 21:46:27 -0600
Message-ID: <8nxAb.4910$nH.4816@bignews6.bellsouth.net>

Hmmm .. my mistake.

I just restested and it does appear ok to even to pass the 32767 characters via a varchar2 column in the parameter list between PlSql procedures.

We are using 8.1.7.4.0 on Sun Solaris 8 for the server and 8.1.7.0.0 for the client .

Note: There is a very descriptive message ( PLS-00215 ) if you try to declare a varchar2 variable at 32K (or 32787). It specifically mentions 32767 as the max.

--
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1070759060.454365_at_yasure...


> Burt Peltier wrote:

>

> > 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) ?

> >

>

> 4K in columns, 32K for the variables in 8i and above. What version do

> you have.

>

> -- 

> Daniel Morgan

> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp

> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp

> damorgan_at_x.washington.edu

> (replace 'x' with a 'u' to reply)

>

Received on Sat Dec 06 2003 - 21:46:27 CST