Errata

"9" deleted

########################################

'(see "Healing Invalids" in Chapter 20)'
should be:
'(see "Recompiling Invalid Code" in Chapter 20)'

INTERVAL DAY TO MONTH
->
INTERVAL YEAR TO MONTH

########################################

It says:

DECLARE
SUBTYPE temperature IS NUMBER;
SUBTYPE coordinate_axis IS PLS_INTEGER;

TYPE temperature_x IS TABLE OF temp INDEX BY coordinate_axis;
TYPE temperature_xy IS TABLE OF tempx INDEX BY coordinate_axis;
TYPE temperature_xyz IS TABLE OF tempxy INDEX BY coordinate_axis;

temperature_3d temperature_xyz;
BEGIN
temperature_3d (1) (2) (3) := 45;
END;
/

It should be:

DECLARE
SUBTYPE temperature IS NUMBER;
SUBTYPE coordinate_axis IS PLS_INTEGER;

TYPE temperature_x IS TABLE OF temperature INDEX BY coordinate_axis;
TYPE temperature_xy IS TABLE OF temperature_x INDEX BY coordinate_axis;
TYPE temperature_xyz IS TABLE OF temperature_xy INDEX BY coordinate_axis;

temperature_3d temperature_xyz;
BEGIN
temperature_3d (1) (2) (3) := 45;
END;
/

Compares two nested tables, and returns FALSE if they differ...
->
Compares two nested tables, and returns TRUE if they differ...

########################################

DBMS_LOB.GET_LENGTH instead of DBMS_LOB.GETLENGTH

INSERT INTO table [(col1, col2, ..., coln)]
AS
SELECT ...;

The correct synthax should be (according to Oracle 10.2 documentation) without AS like that:

INSERT INTO table [(col1, col2, ..., coln)]
SELECT ...;

my_book.isbn
my_book.title
my_book.summary
my_book.author
my_book.page_count

->

my_book_new_info.isbn
my_book_new_info.title
my_book_new_info.summary
my_book_new_info.author
my_book_new_info.page_count

########################################

The code now reads:

CREATE OR REPLACE PROCEDURE order_books (
isbn_in IN name_varray
new_count_in IN number_varray)
IS
BEGIN
FORALL indx IN isbn_in.FIRST ..
isbn_in.LAST
UPDATE books
SET page_count =
new_count_in (indx)
WHERE isbn = isbn_in (index);
END;

it should be:

CREATE OR REPLACE PROCEDURE order_books (
isbn_in IN name_varray
, new_count_in IN number_varray)
IS
BEGIN
FORALL indx IN isbn_in.FIRST ..
isbn_in.LAST
UPDATE books
SET page_count =
new_count_in (indx)
WHERE isbn = isbn_in (indx);
END;

[ lower_bound ... upper_bound |
->
[ lower_bound .. upper_bound |

########################################

'INSERT INTO ' || l_table || ' VALUES (:emp_pky, :new_salary)
->
'INSERT INTO ' || l_table || ' VALUES (:emp_pky, :new_salary)'

########################################

Returns TRUE if the last execution of the SQL statement modified one or more rows.
->
Returns FALSE if the last execution of the SQL statement modified one or more
rows.

########################################

In the statement:

UPDATE books
SET page_count
WHERE isbn = my_books (book_index);

change:
SET page_count
to
SET page_count = page_count / 2

The third bullet point (just before section "ROLLBACK behavior with FORALL") talks
about "deletes and inserts". It should be "deletes and updates", as inserts are
covered by bullet point #2.

the Boolean indices collection had no element defined at position 13067.

should be:

the "values of" collection had no element whose value equaled 13067.

Remove entire bullet item.

joke_category%TYPE
->
joke.category%TYPE

########################################

Remove this text from the 1st sentence:

"(unless declared in a package, which makes the variable
globally accessible)"

Remove the entire bullet item ("A cursor expression can be used as an
argument to table functions,...")

Please change

cols.col_name

to

cols (colind).col_name

2 MB
->
20 MB

########################################

USER_TRIGGERS and USER_TRIG_COLUMNS

should read:

USER_TRIGGERS and USER_TRIGGER_COLS

Note from the Author or Editor:
I have frixed this in OPP6

|| 'Content-Type: multipart/mixed; boundary="' || boundary || '"', 2
->
|| 'Content-Type: multipart/mixed; boundary="' || boundary || '"', 2);

########################################

writedata('Content-Type: text/plain; charset=ISO-8859-1; format=flowed')
->
writedata('Content-Type: text/plain; charset=ISO-8859-1; format=flowed');

########################################

Line 6 of the code listing is missing information:

6 audit_condition => 'SALARY >= 150000,

should be, according to the subsequent description:

6 audit_condition => 'SALARY >= 150000 OR EMPID = 100',

Please change:

Lines 10, 12, 14, 16
These statements use the ANYDATA.ConvertNNN member functions introduced in the Oracle
9i Database Release 2...

to:

Lines 10, 12, 14, 16
These statements use the ANYDATA.AccessNNN member functions introduced in the Oracle
9i Database Release 2...