file_id UTL_FILE.FILE_TYPE;Do you know what the UTL_FILE package is, and how I can fix the above problem in Oracle? Do you know how to determine if it is a privilege issue, fix a UTL_FILE privilege issue or reinstall UTL_FILE if not?
select owner,table_name,grantee,privilege from dba_tab_privs where table_name = 'UTL_FILE';If you need to change permissions on SYS.UTL_FILE, run the following statement:
grant execute on utl_file to <user or public>;In order to write to the file system, the Oracle user must have write permissions to the directory that is listed as a value for the UTL_FILE_DIR init.ora parameter.
To reinstall SYS.UTL_FILE run the following scripts:
$ORACLE_HOME/rdbms/admin/utlfile.sql $ORACLE_HOME/rdbms/admin/prvtfile.plbFor more information on SYS.UTL_FILE see note 315283.1 on Oracle's Metalink. Also see appendix B in "Oracle Database 10g PL/SQL Programming."
This was first published in July 2006