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>


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

Original text of this message