First, you must make sure that the UTL_FILE_DIR parameter is set properly. The file you want to open must be in the directory quantified in the UTL_FILE_DIR parameter. Once that is set, you should be able to open the file and manipulate it as you desire.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.