Re: LONG & VARCHAR2 ?
Date: Thu, 19 Oct 2000 22:04:05 GMT
Message-ID: <8snr4h$oo8$1_at_nnrp1.deja.com>
In article <stapimm1l9mtdc_at_corp.supernews.com>,
"Matt B." <mcb_at_fightspam.sd.znet.com> wrote:
> "Chris Chi" <stvllium_at_ms18.hinet.net> wrote in message
> news:8r1ct4$2if_at_netnews.hinet.net...
> > sSelectedFields VARCHAR2(4000);
> > sSQLCommand VARCHAR2(4000);
> > sAnotherSQLCommand VARCHAR2(4000);
> > sOtherFields VARCHAR2(4000);
>
> Just as a FYI (slightly off topic):
>
> VARCHAR2 has a limit of 2000 as a column in a table Oracle 7, 4000 as
a column
> in a table in Oracle 8, but as a PL/SQL variable I believe it can be
up to
> 32767 in either case.
>
> -Matt
>
>
LONG variables can only contain 32,760 bytes in PL/SQL, seven bytes shorter than a VARCHAR2. However a RAW type in PL/SQL can contain 32,767 bytes; the LONG RAW can only contain 32760 ( a restriction, I suspect, of the implementation of LONG in PL/SQL ).
-- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.Received on Fri Oct 20 2000 - 00:04:05 CEST