Re: Size limitation Dynamic SQL

In article <6ac6hi$e21$1_at_news.worldonline.nl>, "Wilhelm Thieme" The VARCHAR2 limit in PL*SQL is 32000, the limit is 2000 for storing VARCHAR2. I have not pushed the 32000 limit in dynamic SQL, but I have passed the 2000 limit.

James
<w.thieme_at_consunet.nl> wrote:

>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
 

-- 
lorenzen_at_visi.com             | Life is complex; it has
                              |   real and imaginary parts