Edit and Save VPD Profile Results in SYSTEM.FLUSH_SHARED_POOL Error (Doc ID 402288.1)

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 5.0 and later   [Release: 5 and later ]
Information in this document applies to any platform.
Checked for relevance on 16-Apr-2010

Symptoms


When attempting to edit and save Virtual Private Database (VPD) profile,
the following error occurs.

ERROR
{call system.flush_shared_pool()=null}
java.sql.SQLException: ORA-06550: line 1, column 14:
PLS-00904: insufficient privilege to access object SYSTEM.FLUSH_SHARED_POOL
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

STEPS
The issue can be reproduced at will with the following steps:
1. Go to the VPD manager
2. Edit a VPD profile
3. Save < receive error>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms