Re: Size limitation Dynamic SQL

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
Received on Thu Jan 22 1998 - 00:00:00 CST