Errata

Print Print Icon

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. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question



Version Location Description Submitted By Corrected
Printed Page 82
PL/SQL code on page

c_hired_more_than_a_year CONSTANT BOOLEAN := MONTHS_BETWEEN (emp_rec.hire_date, sysdate) > 10 statement should be replaced with
c_hired_more_than_a_year CONSTANT BOOLEAN := MONTHS_BETWEEN (sysdate, emp_rec.hire_date) > 10.

Otherwise months_between generates minus values.

Note from the Author or Editor:
I agree. Change this:

c_hired_more_than_a_year CONSTANT BOOLEAN := MONTHS_BETWEEN (emp_rec.hire_date, sysdate) > 10;

to this:

c_hired_more_than_a_year CONSTANT BOOLEAN := MONTHS_BETWEEN (sysdate, emp_rec.hire_date) > 10;

 Anonymous 
Printed Page 83
sample code at bottom of page

1_title_length PLS_INTEGER
should be:
1_page_length PLS_INTEGER

 Anonymous 
Printed Page 93
The PL/SQL Code started in previous page

The PL/SQL Function "fine" causes an implicit casting from NUMBER to INTEGER. Although the business rule in the example defined to allow any value between $.05 and $.25. The function just truncates the value.

Note from the Author or Editor:
The 6th line from the top of 93 should change to:

RETURN NUMBER;

 Anonymous 
Printed Page 168
1st paragraph

UPDATE book
SET author = 'FEUERSTEIN, STEVEN'
WHERE author = 'FEVERSTEIN, STEPHEN'
RETURNING l_count_modified;

PL/SQL: ORA-00925: missing INTO keyword

Note from the Author or Editor:
Wow. This is a bit nasty. On page 168, everything from "Alternatively, you can..." to the end of the section should be REMOVED. It actually doesn't make any sense.

 Anonymous