Errata

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 xv
URL after fourth paragraph

NOW READS:
http://www.quest-pipelines.com/pipelines/dba/PLVision/plvision.htm

 Anonymous    Nov 01, 2004
Printed
Page 18
Bad URL

http://www.oreilly.com/oracle/oraclep2/

NOW READS:
http://www.oreilly.com/catalog/oraclep2/

 Anonymous    Nov 01, 2003
Printed
Page 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''')

 Anonymous   
Printed
Page 72
5th line from the bottom of the page

LOOP
IF list_in...

NOW READS:

LOOP
EXIT WHEN indx IS NULL;
IF list_in...

 Anonymous    Nov 01, 2003
Printed
Page 99
The paragraph beginning

'Application improvement is likely to improve......'

NOW READS:
'Application performance is likely to improve......'

 Anonymous    May 01, 2006