Errata for Learning Oracle PL/SQL

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.

Book has:
'Reference for PL/SQL developers, '
should be:
'Reference for PL/SQL developers',

Anonymous

Printed

Page 81
4th paragraph

currently reads:
Notice that book_copy_qty returns a VARCHAR2, which is a acceptable
input datatype to concatenate with text and print using PUT_LINE.
Please change that to read:
Notice that the result returned from book_copy_qty gets concatenated
with the 'Number of copies...' string as the argument to PUT_LINE.
(And, if there is space available, please add an asterisk on the word
"result" and the following footnote:
*The function returns a NUMBER, which runtime engine converts to a
string to allow the concatenation to succeed.)

Anonymous

Printed

Page 95
- figure should have arrows to all of the smaller boxes on the

left; all six are public programs

Anonymous

Printed

Page 100
- "add_book.sp" should be "add_book.pro"

Anonymous

Printed

Page 101
- "reporteqnum" should be "reporteqbool"

Anonymous

Printed

Page 109
- The section is "HTML Basics" (Chapter 4). The paragraph before

it notes "The rule says that you must close the inner element before the
outer one. Thus, the following example is logically incorrect:
<OUTER>
<INNER>
This illustrates the RIGHT way to nest elements
</INNER>
</OUTER>"

Anonymous

Printed

Page 122
- "show_time2" show be "show_time"

Anonymous

Printed

Page 123
Bottom of "Creating a DAD" sidebar

"Oraacle9:"
should be
"Oracle9:"

Anonymous

Printed

Page 127
- "add_book_form1" show be "eat_add_book_form"

Anonymous

Printed

Page 128
- "eat_add_book_form1" in text should be "eat_add_book_form"

Anonymous

Printed

Page 152
- "??" should be 200

Anonymous

Printed

Page 154
3rd line of short story

"shot class"
should be
"shot glass"

Anonymous

Printed

Page 156
- "??" should be 200

Anonymous

Printed

Page 156
- "bkcur" should be "bcur " (note space, this is for alignment)