December 2002
Intermediate to advanced
928 pages
85h 29m
English
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 ...