Re: How to prevent using shared pool with dynamic sql pivoting?
From: trbosjek <ivan.petrovski_at_t-mobile.hr>
Date: Sun, 22 Jun 2008 06:01:44 -0700 (PDT)
Message-ID: <0646f092-947b-4ac8-9cbf-1c9d55edf6b6@a1g2000hsb.googlegroups.com>
Date: Sun, 22 Jun 2008 06:01:44 -0700 (PDT)
Message-ID: <0646f092-947b-4ac8-9cbf-1c9d55edf6b6@a1g2000hsb.googlegroups.com>
Anton, you are my hero!
For those who have 10.1.0.3.0, and invalidate procedure is missing from dbms_utility, here's how I did it:
PRAGMA AUTONOMOUS_TRANSACTION;
.
.
.
dbms_job.submit(t_id,'EXECUTE IMMEDIATE ''ALTER TYPE PivotImpl COMPILE
BODY'';');
Received on Sun Jun 22 2008 - 08:01:44 CDT