Re: Dynamic SQL and Database Links

I thougth the original reference to 2000 was the size of an sql statement which could be parsed by DBMS_SQL. That's why I asked if that wasn't 32000.

• Alton

Jonathan Lewis wrote:

> Just received a correction from Christopher Beck
> The varchar2s() is still varchar(256) in 8i.
>
> I was thinking of the Varchar2_table type, of
> varchar2(2000) used for bind arrays. (which
> really is a new feature in 8.0).
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> Jonathan Lewis wrote in message
> <931984950.26309.0.nnrp-14.9e984b29_at_news.demon.co.uk>...
> >It keeps changing -
> >
> >In v7 it was 2,000 characters at some stage (I think,
> >but I can't prove it), and the varchar2s() type was a
> >table of varchar2(256)
> >
> >In v8.0 the limit the varchar2s is a table of varchar2(2000)
Received on Thu Jul 15 1999 - 08:39:31 CDT