Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page