Unable to edit VPD

[Rajashree]

Hi

I am trying to edit a VPD. After opening the VPD and making the changes and then clicking on 'Save', I am getting the error:

{call system.flush_shared_pool()=null}


java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'SYSTEM.FLUSH_SHARED_POOL' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Any suggestions?

The other problem is for a VPD to take effect, I need to restart the server. Is there something that needs to be changed in the Properties file?

Thanks
Rajashree

[ravintag]

Re: Unable to edit VPD

Hi Rajashree,

The problem sometime comes when you are trying to edit the external predicate content of an already created VPD, to solve this problem we used to delete the old VPD and create a new one and it worked fine.

There is a problem while editing VPD and it is throwing this error, the round about is creating a new one and deleting the old instead of editing. I have encountered this problem with 5.0 version.

Let me know if this was helpful.

[neoandr]

Re: Unable to edit VPD

Shree,
even i faced the same problem in version 5.0 whenever i tried to edit it.
To me OTM has no provision of deleting VPD from front end, so we used to delete it from backend or CSV and then create a new one as workaround.

not sure why this problem occurs.... heard tht it might be cache but not sure.

thanks,
-neoandr

[Rajashree]

Re: Unable to edit VPD

Hi

Even if I delete the old VPD (either through front end or back end), there is still the issue of VPD getting effect only if the server is restarted. Does this require any change in the Properties file?

Rajashree

[sprabhakar]

Re: Unable to edit VPD

From version 5.0, any changes to the VPD automatically clears the shared pool on the database server. This is done to clear out any cached execution plans/queries.

To avoid the above error, the DBA needs to create the stored procedure "flush_shared_pool" (available in the glogowner schema ) in the "system" schema and grant execute rights to glogowner and glogdba.

Once this is done, the VPD changes will take effect without a restart of the application server.