What is an UTL_FILE.What are different procedures and functions associated with it?

UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, PUT_LINE, NEW_LINE, PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

Showing Answers 1 - 2 of 2 Answers


  • Mar 20th, 2007

utl_file is oracle procedure tht enable file access .You can write ,read to file.Also possible is to del or rename a file.It requires the use of a directory object.

  Was this answer useful?  Yes


  • Feb 6th, 2008

With the Oracle-supplied UTL_FILE package, you can read from and write to operating system files. It Provides security for directories on the server through the init.ora file. UTL_FILE Procedures and Functions:

• Function FOPEN

• Function IS_OPEN

• Procedure GET_LINE

• Procedure PUT, PUT_LINE, PUTF

• Procedure NEW_LINE

• Procedure FFLUSH


  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions