identifier 'UTL_FILE' must be declared
10438Jul 5 2005 — edited Jun 4 2012Hello All,
Suddenly I am finding some of my system objects invalid.
They all have same kind of comiling error.
Owners are Public (2 synonym), DMSYS (3 Package body), OLAPSYS (11 Packages body),XDB (2 packages body) & FLOWS_010500 (1 Procedure, 7 Packages body)
Errors are same as below:
DMSYS PACKAGE BODY DBMS_DM_UTIL
Line # = 5 Column # = 19 Error Text = PLS-00201: identifier 'UTL_FILE' must be declared
Line # = 5 Column # = 19 Error Text = PL/SQL: Item ignored.
Are there any priveiges issue or I am missing any utl_file objcet.
If I need to rienstall utl_file object, what is the best way to do it.
cheers,
D