Re: Huge Query

From: DA Morgan <>
Date: Thu, 02 Oct 2008 15:27:11 -0700
Message-ID: <>

Ed Prochak wrote:

> On Oct 2, 7:53 am, CenturionX <> wrote:

>> Hello everybody,
>> I created a package to build a query. This query has a bui dynamic
>> quantity os calculated fields and it overflows a simple VARCHAR2(4000)
>> so i'm using a CLOB.
>> My question is: How can i execute this query referencing the variable
>> Is there something like EXECUTE vQuery inside a procedure or package.
>> Thanks.
> I'd seriously question the logic of a query that cannot fit into a

I would too but the answer, in Oracle, is that you can build a query of 8TB size if you wish using DBMS_SQL.

Go to Morgan's Library at
Look up the DBMS_SQL package
Scroll down to "EXECUTE_PLSQL_BLOCK"

Daniel Morgan
Oracle Ace Director
University of Washington Received on Thu Oct 02 2008 - 17:27:11 CDT

Original text of this message