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


The unconfirmed error reports are from readers. They have not yet been 
approved or disproved by the author or editor and represent solely the
opinion of the reader.

If you have technical questions or error reports, you can send them to 
booktech@oreilly.com. (Please specify the printing date of your copy.)


This page was updated March 12, 2003. 


Here's a key to the markup:

        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification


UNCONFIRMED errors and comments from readers: 


[90]  2nd paragraph (sample code);
the current line is

  for colind in 1..ncols
  loop
*  dbms_output.put_line(cols.col_name);
  end loop;

The cols is of type dbms_sql.desc_tab which is table of dbms_sql.desc_rec.So
to access the column name from the cols the code should be as follows

  for colind in 1..ncols
  loop
*  dbms_output.put_line(cols(colind).col_name);
  end loop;


[395]  4th bullet;
In the book, it stated that if you try to open a file for append, it must exist or else it will raise INVALID_OPERATION exception.

While Oracle documentation stated, "If you open a file that does not exist using the a value for open_mode, then the file is create
d in write (w) mode.