not able to compile package which uses dba_directories in 11gR2
We are trying to upgrade the data base from Oracle 10g to 11gR2, and one of our custom package is failing compilation throwing error "PL/SQL: ORA-00942: table or view does not exist" for dba_directories
package code snippet is
SELECT directory_pathINTO v_pathFROM dba_directoriesWHERE directory_name = v_dir;are there any restriction added in Oracle 11gR2?
Rgds,
-Kamal