Oracle Built-in Packages
by Steven Feuerstein, Charles Dye and John Beresniewicz


Following are the changes made in the 9/99 reprint:


(392) The following has been added after VALUE_ERROR in list of
exceptions:

        INVALID_MAXLINESIZE

	Oracle 8.0 and above: Raised when you try to open a
	file with a maximum linesize outside of the valid
	range (between 1 through 32767).


(393) Changed the first bullet item to:

        Prior to Oracle 8.0, you cannot read or write a line of text
	with more than 1023 bytes. In Oracle8.0 and above, you can 
	specify a maximum line size of up to 32767 when you open a file.


{394} Under UTL_FILE.FOPEN, changed the program header to a two column
format like this:

 All PL/SQL versions:           Oracle 8.0 and above only:
 FUNCTION UTL_FILE.FOPEN (      FUNCTION UTL_FILE.FOPEN (
    location     IN VARCHAR2,      location     IN VARCHAR2,
    filename     IN VARCHAR2,      filename     IN VARCHAR2,
    open_mode    IN VARCHAR2)      open_mode    IN VARCHAR2,
 RETURN file_type;                 max_linesize IN BINARY_INTEGER)
                                RETURN file_type;

and added the following to the parameter list:

        max_linesize

	The maximum number of characters per line, including the
        newline character, for this file. Minimum is 1, maximum is
	32767.


{395} Added the following to the list of exceptions:

        UTL_FILE.INVALID_MAXLINESIZE


{459} 3 exceptions are referenced:

    DBMSLOB.NOEXIST_DIRECTORY
    DBMSLOB.NOPRIV_DIRECTORY
    DBMSLOB.INVALID_DIRECTORY

There is now an underscore in 'DBMS_LOB'.