Oracle PL/SQL Best Practices

Errata for Oracle PL/SQL Best Practices

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 "Date 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 Note Update



Version Location Description Submitted By Date Submitted Date 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  Aug 20, 2008 
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  Aug 20, 2008 
PDF
Page 111
2nd paragraph

I think the package is "FORMAT_ERROR_BACKTRACE", in the index occurrs the same. "DBMS_UTILITY.FORMAT_BACK_TRACE Starting with Oracle Database 10g Release 2, use DBMS_UTILITY.FORMAT_ BACK_TRACE to obtain the line number on which the most recent exception was raised. This is a critical piece of information, long missing in PL/"

Note from the Author or Editor:
Yes, this person is right. Any reference in the entire book to DBMS_UTILITY.FORMAT_BACK_TRACE should be changed to DBMS_UTILITY.FORMAT_ERROR_BACKTRACE

juan alberto rodriguez villena  Mar 24, 2011 
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  Oct 08, 2008