Re: Limit on size of Query?

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Fri, 12 Apr 2002 22:55:10 +0100
Message-ID: <3CB757BE.953B8D52@exesolutions.com>

I have submitted them far in excess of 32K which is the maximum size of a VARCHAR2 and never had a problem.

Daniel Morgan

ARP wrote:

> Is there a known limit on the size (number of characters) of an SQL query
> that can be submitted to the Oracle database engine?
> Is the allowed size determined by where the query is submitted? i.e. is
> there a different limit on the size for queries submitted via SQL Plus as
> opposed to using the Oracle OLEDB provider under program control?
>
> I have been struggling for a little while now with submitting a query that
> is 4571 characters long. How is this problem usually circumvented?
>
> Thanks for your thoughtful responses.
> arp.
Received on Fri Apr 12 2002 - 16:55:10 CDT