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