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

From: <jerryd_at_webex.com>
Date: Tue, 07 Nov 2000 20:03:00 GMT
Message-ID: <8u9n5e$g1$1@nnrp1.deja.com>

If you make sure that the query is correct. You can try this. set pagesize 0
set linesize 1000

your SQL

set pagesize 24
set linesize 80

In article <0ajg0ts289gfocjs1p9dpkn7csuamt3lql_at_4ax.com>, Yurasis Dragon <yurasis_spamNOSPAM_at_yahoo.com> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 07 2000 - 14:03:00 CST