Oracle in a Nutshell

Calls

PROCEDURE UTL_FILE.FCLOSE (file IN OUT FILE_TYPE);

Closes the file identified by file handle file and sets the value of file ID to NULL.

PROCEDURE UTL_FILE.FCLOSE_ALL;

Closes all opened files; however, the ID fields of any file handles will not be set to NULL.

PROCEDURE UTL_FILE.FCOPY (location IN VARCHAR2, filename IN VARCHAR2, dest_dir IN VARCHAR2, dest_file IN VARCHAR2, start_line IN PLS_INTEGER DEFAULT 1, end_line IN PLS_INTEGER DEFAULT NULL);

Copies filename in location to dest_file in dest_dir. start_line and end_line are used to copy a portion of filename. New with Oracle9i.

PROCEDURE UTL_FILE.FFLUSH (file IN FILE_TYPE [, invalid_maxlinesize EXCEPTION]#);

Forces any buffered data for file handle file to be written out immediately. invalid_maxlinesize (new with Oracle9i) can be INVALID_FILENAME, INVALID_OPERATION, or WRITE_ERROR.

PROCEDURE UTL_FILE.FGETATTR (location IN VARCHAR2, filename IN VARCHAR2, exists OUT BOOLEAN, file_length OUT NUMBER, blocksize OUT NUMBER);

Returns attributes exists, file_length, and blocksize of filename in location. New with Oracle9i.

FUNCTION UTL_FILE.FGETPOS (fileid IN FILE_TYPE) RETURN PLS_INTEGER;

Returns the current offset position in fileid, in bytes. New with Oracle9i.

PROCEDURE UTL_FILE.FREMOVE (location IN VARCHAR2, filename IN VARCHAR2);

Deletes filename in directory location. New with Oracle9i.

PROCEDURE UTL_FILE.FRENAME (location IN VARCHAR2, filename IN VARCHAR2, dest_dir IN VARCHAR2, dest_file IN VARCHAR2, overwrite IN BOOLEAN ...