If you have the init.ora parameter utl_file_dir = /tmp set, then I don't see why your operation won't work. The documentation provides good examples of how to use UTL_FILE, so I'd review those too. If you want more detailed help, you need to provide more detailed error messages. You do not need DBA access to use UTL_FILE, but you may need DBA access to check or change the setting for utl_file_dir in the init.ora file.
Dig Deeper on Oracle database security
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.