not able to compile package which uses dba_directories in Oracle 11gR2
We are trying to upgrade the data base from Oracle 10g to 11gR2 (and e-biz R12.1.3), 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_path
INTO v_path
FROM dba_directories
WHERE directory_name = v_dir;
are there any restrictions added in Oracle 11gR2?
Rgds,
-Kamal