Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL and Database Links

Re: Dynamic SQL and Database Links

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 14 Jul 1999 22:50:42 +0100
Message-ID: <931989346.11878.0.nnrp-11.9e984b29@news.demon.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US