Re: Huge Query
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 02 Oct 2008 15:27:11 -0700
Message-ID: <1222986623.316568@bubbleator.drizzle.com>
>> 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.
Daniel Morgan
Oracle Ace Director
University of Washington Received on Thu Oct 02 2008 - 17:27:11 CDT
Date: Thu, 02 Oct 2008 15:27:11 -0700
Message-ID: <1222986623.316568@bubbleator.drizzle.com>
Ed Prochak wrote:
> On Oct 2, 7:53 am, CenturionX <darwinbaldr..._at_gmail.com> 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 > VARCHAR2.
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 www.psoug.org
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