Re: Maximum length sql statement

From: David Fitzjarrell <oratune_at_aol.com>
Date: Tue, 14 Nov 2000 15:51:35 GMT
Message-ID: <8urn23$4um$1@nnrp1.deja.com>

In our last gripping episode Roman Starek <starek_at_pluto.spsselib.hiedu.cz> wrote:
> cho <cho_at_sondagsavisen.dk> wrote:
> > i cant seem to get more than 295 chars at a time.. Oracle wont have
it, and
> > willignore anything i put more, telling me i im missing right
parenthesis.

> > I need to do a create longer than this, what to do ?
>
> Ora doc says
>
> QL statement length
>
> 64 K maximum length; particular tools
> may have lower limits
>
> Starous
>
>

And the length limit for a single line is 2500 characters.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Tue Nov 14 2000 - 09:51:35 CST