Oracle PL/SQL Programming

Errata for Oracle PL/SQL Programming

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
Page xxxiii
1st paragraph

The second sentence says: You might also want to visit PL/SQL Obsession (Steven Feuerstein’s PL/SQL portal) at ,, where you will find training materials, code downloads, and more. In the PDF, the first dot is actually the link to his page, which is -

Note from the Author or Editor:
Yes, PL/SQL Obsession is now old and will soon be retired. Instead, it would be better to change this to: You might also want to visit the Oracle PL/SQL Learning Library, at, where you will find resources from both Steven and other PL/SQL experts.

Anonymous  Apr 10, 2015 
Printed, PDF
Page 156
First Line

Currently the line reads as: "example, I trap two parent-child exceptions, −1 and −2292, and then take an action" The "-2292" is incorrect, it should be "-2291". That is the correct error number (-2292 is raised during a DELETE statement) and agrees with the error used in the code for the add_company() procedure.

Note from the Author or Editor:
Please make the change as directed by this careful reader.

Anonymous  Sep 22, 2014