Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What is the limit of a sql string ...

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

From: David Fitzjarrell <oratune_at_aol.com>
Date: Tue, 07 Nov 2000 20:20:06 GMT
Message-ID: <8u9o5c$1hs$1@nnrp1.deja.com>

In our last gripping episode jerryd_at_webex.com wrote:
> 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.
>

I doubt that your suggestion will have any effect on the results.

The command-line limit is 2500 characters, that is, one single line of SQL text can extend to 2500 characters before a new line must be created. If there is any way you can divide the query into 2500 character pieces (you should end up with at least 54 lines of code) you will most likely have success running it. I would try looking for natural breaks in the code, examples of which would be:

Keywords, such as:

Select
From
Where
And
Or
Order by
Group by
Having

Punctuation:

commas
concatenation (||)

I hope this helps.

--
David Fitzjarrell
Oracle Certified DBA


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US