Oracle PL/SQL Programming, 3rd Edition
by Bill Pribyl, 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 updated on April 8, 2005.

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:


{109}  Section titled 'The simple loop';
The second sentence reads: "Notice the IF statement used to guard against executing
the loop when the maximum rank is negative."  There is no IF statement in the code.


(328)  Code in the second bulletted list;
The fourth element in the record structure is actually --

total_sales company_sales_cur.total_sales%TYPE := 0,

but there was a mino typo and it reads --

total_sales company-sales.total_sales%TYPE := 0,


(342) IN PRINT: 2nd line from the top:

INDEX BY VARCHAR2(size_limit)

SHOULD BE:

INDEX BY PLS_INTEGER
INDEX BY NATURAL
INDEX BY POSITIVE
INDEX BY VARCHAR2(size_limit)
INDEX BY table.column%TYPE
INDEX BY package.variable%TYPE
INDEX BY subtype

where the datatype of any anchored type or subtype resolves to VARCHAR2.


{357}  5th line;
"...i is greater then COUNT..."
should be:
"...i is greater than LAST..."


(390)  1st paragraph;
capitalization is not the normal standard on this page
e.g. "into", "varchar2", "column_value", "cast"


(464) figure 13-4;
PRAGMA
   AUTONOMOUS_TRANSACTION

should be:

PRAGMA
   AUTONOMOUS_TRANSACTION;


(693)  6th line of code from the bottom;
"INTEAD OF..."
should be:
"INSTEAD OF..."


{698}  top, code sample;
In this INSTEAD OF DELETE trigger, the reference to 
:NEW.delivery_end (in 2 places)
should be: 
:OLD.delivery_end.