Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Long columns obsolete
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 BortelReceived on Sun Dec 07 2003 - 05:15:54 CST