Re: How to prevent using shared pool with dynamic sql pivoting?

From: trbosjek <>
Date: Sun, 22 Jun 2008 06:01:44 -0700 (PDT)
Message-ID: <>

Anton, you are my hero!

For those who have, 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

Original text of this message