Does Dom's article on VPD and Result cache help? http://orastory.wordpress.com/2009/02/19/a-bit-of-vpd-and-a-dollop-of-result-cache/ Just a little bit extra to try to avoid the overquoting sin On Fri, Jun 8, 2012 at 4:07 PM, Chris Dunscombe <cdunscombe@xxxxxxxxx>wrote: > Hi, > We have a stored procedure with a cursor. This cursor has the result_cache > hint. > > The app is Oracle App Server 10.1.3 and connects using application connect > pools to the database via a proxy user with role information etc coming > from OID. > OLS is being used. > > -- Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l