Huge Query
From: CenturionX <darwinbaldrich_at_gmail.com>
Date: Thu, 2 Oct 2008 05:53:22 -0700 (PDT)
Message-ID: <facaf0db-c0ee-4794-a8e4-fdd619a4488e@2g2000hsn.googlegroups.com>
Date: Thu, 2 Oct 2008 05:53:22 -0700 (PDT)
Message-ID: <facaf0db-c0ee-4794-a8e4-fdd619a4488e@2g2000hsn.googlegroups.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. Received on Thu Oct 02 2008 - 07:53:22 CDT