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

I believe sql*net may be the problem. I believe SQL*NET packages are limited to 32K (O7) and 64K (O8). One experiment you can do is to shut Oracle down, turn tracing on in the init.ora file, restart Oracle, run the query, and look in the log to see what query Oracle tried to run. Don't forget to turn tracing back off, its a pretty expensive process in terms of performance and disk space.
Dave

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.
Received on Thu Nov 09 2000 - 20:15:53 CST