Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Compile UTL_FILE PACKAGE BODY

M.M.RJul 31 2009 — edited Jul 31 2009

Hi ALL,,,

I refreshed one db from PROD dump.

After that I compiled all Invalid objects .But am unable to compile UTL_FILE PACKAGE BODY

Showing all are invalid.

OBJECT_NAME OBJECT_TYPE OWNER
-------------------- ------------------- ------------------------------
UTL_FILE PACKAGE BODY UTLFILE
UTL_FILE_EX PACKAGE BODY UTLFILE
UTL_FILE_ADMIN PACKAGE BODY UTLFILE

SQL> show parameter utl

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
create_stored_outlines string
utl_file_dir string

Please help me how to compile this.

If I tried to copile manualyy..I am gettimg Error like..PACAGE ALTERED WITH COMPILATION Errors.

Thanks
Manohar.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 28 2009

Added on Jul 31 2009

#general-database-discussions

2 comments

1,110 views