Oracle PL/SQL Programming, Fourth Edition
by Steven Feuerstein, Bill Pribyl


The following errata were *corrected* in the ____ reprint:


This page was updated February 21, 2007 


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
	+n:  n'th paragraph from the top of the page
	-n:  n'th paragraph from the bottom of the page


########################################

{8} Line 9 of code

"9" deleted

########################################

(150) Code example

CREATE OR PROCEDURE ...
->
CREATE OR REPLACE PROCEDURE ...

########################################

{268} -1, 6th sentence

INTERVAL DAY TO MONTH
->
INTERVAL YEAR TO MONTH

########################################

{373} Summary table, row 2 (<> or !=), Description column

Compares two nested tables, and returns FALSE if they differ...
->
Compares two nested tables, and returns TRUE if they differ...

########################################

{434} last code example 

my_book.isbn
my_book.title
my_book.summary
my_book.author
my_book.page_count

->

my_book_new_info.isbn
my_book_new_info.title
my_book_new_info.summary
my_book_new_info.author
my_book_new_info.page_count

########################################

{437} first code example

[ lower_bound ... upper_bound |
->
[ lower_bound .. upper_bound |

########################################

{441} last bullet of example

'INSERT INTO ' || l_table || ' VALUES (:emp_pky, :new_salary)
->
'INSERT INTO ' || l_table || ' VALUES (:emp_pky, :new_salary)'

########################################

{441} Table 14-2, Description column, second row

Returns TRUE if the last execution of the SQL statement modified one or more rows.
->
Returns FALSE if the last execution of the SQL statement modified one or more
rows.

########################################

(473-474) Example at the bottom, and top of next page (occurs twice)

l_isbn
->
isbn_in

########################################

{488} last line

joke_category%TYPE
->
joke.category%TYPE

########################################

(492) first code example

FROM transportation
BULK COLLECT INTO names, mileages
->
BULK COLLECT INTO names, mileages
FROM transportation

########################################

(493) code example

FROM transportation
BULK COLLECT INTO l_transportation
->
BULK COLLECT INTO l_transportation
FROM transportation

########################################

{653} -1

2 MB
->
20 MB

########################################

{806} line 48

|| 'Content-Type: multipart/mixed; boundary="' || boundary || '"', 2
->
|| 'Content-Type: multipart/mixed; boundary="' || boundary || '"', 2);

########################################

{806} line 51

writedata('Content-Type: text/plain; charset=ISO-8859-1; format=flowed')
->
writedata('Content-Type: text/plain; charset=ISO-8859-1; format=flowed');

########################################