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

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