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

<scheffer_at_amis.nl> schreef in bericht
news:24c038af-c4db-46fc-904c-9c9b4de4e266_at_p25g2000hsf.googlegroups.com...
> 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

Thank you Anton!

Shakespeare Received on Fri Jun 20 2008 - 03:46:12 CDT