EBS Customizations (MOSC)

MOSC Banner

not able to compile package which uses dba_directories in Oracle 11gR2

edited Jul 28, 2011 4:42PM in EBS Customizations (MOSC) 3 commentsAnswered ✓
Hi,

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

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