Re: What is the limit of a sql string ...

Actually, the problem was first manifest by our developer when this query was generated via Cold Fusion. She captured the query and in SQL*Plus we got the ORA-01756. From the error message in Cold Fusion, it sounded like some kind of truncation, hence syntax, error.

On Tue, 07 Nov 2000 20:48:59 GMT, Frank van Bortel <fbortel_at_home.nl> wrote:

>If fired from a Windows PC, the limit would be some 32kB.
>Try svrmgrl on the server side, it has a similar limit, but
>higher (64k? In which case it would help much...)
>
>It's been a bug/enhancement request which is implemented
>in 8i, where the size is upped quite a lot, "making it virtually
>impossible to hit this error again".
>
>History: used to be annoying with web server generator of
>Designer, which quite happily generated packages over 32kB.
>
>Yurasis Dragon wrote:
>
>> that is submitted.
>>
>> We have a developer that is submitting an sql query whose
>> filesize is 133,503 bytes, including whitespace. Once this
>> query is run this error is returned
>>
>> TEST1 > ERROR:
>> ORA-01756: quoted string not properly terminated
>>
>> Syntactically the query is correct but I'm guessing that the
>> string is being truncated somewhere so this error is returned.
>>
>> I have run this query using SQL*Plus on a PC as well as on
>> our Solaris server.
>>
>> Does anyone have an idea what the limit is and if the default
>> can be changed?
>>
>> Thanks in advance for the help.
>
>--
>Gtrz,
>
>Frank van Bortel
>
>
  Received on Tue Nov 07 2000 - 20:06:32 CST