Read and write operating system text files.
FOPEN returns a file handle, which you use in subsequent calls to GET_LINE or PUT to perform stream I/O to a file. When file I/O is done, call FCLOSE to complete any output, and free resources associated with the file.
Subprocedures: FOPEN Function Open a file for input or output with the default line size. FOPEN Function Open a file with the maximum line size specified. FOPEN_NCHAR Function Open a file in Unicode for input or output. FOPEN_NCHAR Function Open a file in Unicode for input or output, with the maximum line size specified. IS_OPEN Function Determine if a file handle refers to an open file. FCLOSE Closes a file. FCLOSE_ALL Closes all open file handles. GET_LINE Read text from an open file. GET_LINE_NCHAR Read text in Unicode from an open file. PUT Write a string to a file. PUT_NCHAR Write a Unicode string to a file. NEW_LINE Write one or more operating system-specific line terminators to a file. PUT_LINE Write a line to a file. This appends an operating system- specific line terminator. PUT_LINE_NCHAR Write a Unicode line to a file. PUTF A PUT procedure with formatting. PUTF_NCHAR A PUT_NCHAR procedure with formatting. Writes a Unicode string to a file, with formatting. FFLUSH Physically write all pending output to a file.
For full documentation of the packaged procedures
above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al