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

So it has nothing to do with the file size, then? Could be a long line (as David pointed out, a single line of sql code can be up to 2500 characters), that was wrapped (most terminal emulations wrap at 80 or 132, doubt there is any program that will do 2500 chars on a single line).
This wrapping can/will be interpreted as a cr/lf, which in turn can cause the error. Will take some searching in the code, but a twice wrapped line with 200 characters is different than 2 lines of 80, plus a third with 40... My best guess is that you will 'have a quoted string in your code' wrapped like this. Make sure it reads

'have a quoted string in your code' - 1 line, or concatenate:
'have a quoted string in'||
' your code'

Yurasis Dragon wrote:

> 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
> >
> >

--
Gtrz,

Frank van Bortel