Re: Size limitation Dynamic SQL

From: Wilhelm Thieme <w.thieme_at_consunet.nl>
Date: 1998/01/23
Message-ID: <6ac6hi$e21$1@news.worldonline.nl>#1/1

I thought it was 32k, before I start using it I want to be sure ...

Jan Vissers wrote in message <34C6AAED.89C6F9A5_at_pi.net>...
>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 Fri Jan 23 1998 - 00:00:00 CST