Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL and Database Links
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 Wed Jul 14 1999 - 16:50:42 CDT
![]() |
![]() |