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

Add the following to member function ODCITableClose

    select object_id
    into t_id
    from user_objects
    where object_name = 'PIVOTIMPL' -- name of your type!     and object_type = 'TYPE BODY';
-- invalidating of the type body forces that ODCITableDescribe is
executed for every call to the pivot function
-- and we do need that to make sure that any new columns are picked up
(= new values for the pivoting column)

    dbms_utility.invalidate( t_id );

--

Anton