Limit on size of Query?

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 - 18:57:49 CDT