Errata
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 |
---|---|---|---|---|
Other Digital Version | Line 105 central_error_log.sql on Website |
Line 105 should read: |
Brian Kretch | Dec 20, 2018 |
Printed | Page 7 Code example |
The update statement replaces any occurrence of "STEVEN" in the column 'author' for the selected rows. With this, the names of any of your co-authors that contain "STEVEN", will also be changed. |
Mai Ho | Apr 20, 2017 |
Printed | Page 63 3rd paragraph |
The example procedure header is calc_totals. |
Roberto Hernandez | Apr 12, 2015 |
Page 293 last rows |
"Any fractional number of years (in this case 0.5) will be converted to an equivalent number of months, with the result being rounded to an integer. Thus, 10.9 years will convert to an interval of 10 years, 10 months". |
Filippo | Feb 17, 2014 | |
Page 299 3rd row under "The EXTRACT Function" Title |
EXTRACT (component_name, FROM {datetime | interval}) |
Filippo | Feb 17, 2014 | |
Page 311 1st word of 7th row |
fmanage |
Filippo | Feb 17, 2014 | |
Page 319 2nd block of code |
TYPE customer_sales_rectype IS RECORD |
Filippo | Feb 17, 2014 | |
Page 428 SQL output |
Both the query using |
Filippo | Apr 17, 2014 | |
Printed | Page 690 First paragraph |
The text should read: "You can find the implementation of one such centralized error-handling package in the central_error_log.sql file..." instead of "...in the error_log.sql file....". |
Brian KRetch | Dec 20, 2018 |
Printed | Page 700 There are 2 spots in the code |
The code has: |
Brian Kretch | Dec 21, 2018 |
Printed | Page 834 Line 33 in script |
Line 33 is missing a right parenthesis at the end of the line. It should read: |
Brian Kretch | Jan 02, 2019 |
Printed | Page 876 PROCEDURE move_buffer_to_log.sp |
I am running the procedure on Oracle 12.2.0.1. I have found that the procedure move_buffer_to_log gets in an infinite loop because the dbms_output.get_lines function call always returns (in addition to the text in the dbms_output buffer) a single NULL line at the end. Hence, when the buffer gets called to return the last 100 lines of text, even if it is empty, it returns a single NULL line. In turn, the EXIT WHEN l_buffer.COUNT condition is never = 0, and the loop never terminates. I put a loop to remove all lines from the buffer where the line was NULL (no characters) before checking the l_buffer.COUNT=0 condition, and it worked fine. |
Brian Kretch | Jan 14, 2019 |
Printed | Page 1004 The $IF Directive |
$ELSEIF should be $ELSIF |
Frodo Looijaard | Nov 20, 2014 |