Errata

Oracle Built-in Packages

Errata for Oracle Built-in Packages

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page 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;

 Anonymous   
Printed Page 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.

 Anonymous