PL/SQL (MOSC)

MOSC Banner

not able to compile package which uses dba_directories in 11gR2

edited Jul 28, 2011 5:09AM in PL/SQL (MOSC) 5 commentsAnswered ✓
Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center