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:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
$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."
Dig Deeper on Using Oracle PL-SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.