Oracle PL/SQL Best Practices
By Steven Feuerstein


This errata page lists errors outstanding in the most recent printing.

If you have technical questions or error reports, you can send them to
booktech@oreilly.com.  (Please specify the printing date of your copy.)


This page was last modified on September 21, 2006.


Here's a key to the markup:
        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification


Confirmed errors:


[42]  Second code example;
As a much better approach it is written:

DECLARE
  my_birthdate DATE :=
    TO_DATE ('09-SEP-58', 'DD-MON-RR');

Still this code is relying on the external setting of NLS_DATE_LANGUAGE.

The code should thus be:

DECLARE
  my_birthdate DATE :=
    TO_DATE ('09-SEP-58', 'DD-MON-RR', 'NLS_DATE_LANGUAGE=''AMERICAN''')