Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Long columns obsolete
Ooops... 32787 was definitely a type-o .
I meant, as you said, 32768.
-- "Frank" <fbortel_at_nescape.net> wrote in message news:bqv1kt$b2i$1_at_news3.tilbu1.nb.home.nl...Received on Sun Dec 07 2003 - 11:29:26 CST
> Burt Peltier wrote:
>
> > 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.
> >
> [snip]
> 32 * 1024 = 32768
> Maximum length is usually (xxxKB - 1), e.g. maximum
> length for a CLOB is (2^32 - 1) byte.
> I presume the -1 has to do with the \0 for character fields,
> and the 0 as value for numeric fields.
>
> Where does your 32787 come from - typo, I presume?
>
> You can also pass clobs, if you require more than 32k of text
> to pass from one procedure to another
> --
> Regards, Frank van Bortel
>