Re: Maximum length sql statement

From: <sybrandb_at_my-deja.com>
Date: Tue, 14 Nov 2000 12:05:03 GMT
Message-ID: <8ur9pd$plf$1@nnrp1.deja.com>

In article <7k7Q5.41$ct1.2337_at_news.get2net.dk>, "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 ?
>
> thx.
>
>

Oracle definitely allows more than 295 chars, IIRC the limit is 32k. So it looks like you are missing a right parenthesis. Please post the affected sql statement to get to the point answers.

HTH

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


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

Received on Tue Nov 14 2000 - 06:05:03 CST