Re: Size limitation Dynamic SQL

Hi
Starting around 7.3 it is also possible to parse a table of varchar2(256), maybe this helps.

Regards,
Urs

Guess? wrote:

> Jan Vissers wrote:
> >
> > DBMS_SQL.PARSE(
> > c IN INTEGER,
> > statement IN VARCHAR2,
> > language_flag IN INTEGER);
> >
> > The size limit for parsing SQL statements with the syntax above is
> > size_t, which is the largest possible contiguous allocation on the
> > machine being used.
> >
> > Wilhelm Thieme wrote:
> >
> > > Hi,
> > >
> > > What is the limitation in size (length) of a SQL statement executed
> > > using
> > > dynamic SQL (package DBMS_SQL).
> > >
> > > Thanks
> > > Wilhelm
>
> The Size limit is the length of a VARCHAR2 field i.e. 2000 .

--
Urs Meier (umeier_at_trivadis.ch)
Trivadis AG
Elisabethenanlage 9
CH-4051 Basel
Phone +41 61 279 97 55
Fax   +41 61 279 97 56
http://www.trivadis.com