Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Size limitation Dynamic SQL
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 . Received on Wed Jan 21 1998 - 00:00:00 CST