Re: How to prevent using shared pool with dynamic sql pivoting?
Date: Sun, 22 Jun 2008 06:01:44 -0700 (PDT)
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:
dbms_job.submit(t_id,'EXECUTE IMMEDIATE ''ALTER TYPE PivotImpl COMPILE BODY'';'); Received on Sun Jun 22 2008 - 08:01:44 CDT