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

From: <>
Date: Fri, 20 Jun 2008 00:10:10 -0700 (PDT)
Message-ID: <>

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 );


Received on Fri Jun 20 2008 - 02:10:10 CDT

Original text of this message