Errata

>{AutoCommit} = 0

--- snip ----------------------------------------------------
The recommended way to implement robust transactions in Perl applications is to use
RaiseError and eval { ... }
--- snip -----------------------------------

The cursor was left on the page when the screen shot was taken, which makes these illustrations
sometimes confusing or hard to read. For instance, on page 32, you cannot tell if it is
"simple_loop()", "simple_loop(<something unintelligible>)", or "simple_loop)", and when first
learning the syntax of something, I think you need clearer examples.

This happens on 25, 27, 28, 29, 32, 34, 35, 36, 38, 42, 160, 164. In the early part of the book,
there are places where it is difficult to see parenthesis and such due to cursor or insert point,
or sometimes a selected character as if in the middle of a cut-and-paste operation.

The procedure defined in Figure 2-10 defines total_sales
to be type NUMERIC(8,2); however when the result is printed
out the value is displayed as 7 digits before the decimal
place and none after it - a NUMERIC(8,2) would have up to
six characters before the decimal point and 2 after it,
which means that the result doesn't even fit in the variable
and it displays as 999999.99!
Also, using the example database, I got the answer:
Total sales for 2 is 7270844.00
which is different from the answer printed in the book.

Stored procedure CALLs for 1_new_salary procedure. I can't find how to create this stored
procedure.

Also, on page 41, example 2-8 CALLs cursor_example2(18) instead of putting_it_all_together(18).

"requirements will be minimal and, use CHARs and VARCHARs can be used"
should probably be
"requirements will be minimal and, because CHARs and VARCHARs can be used"

"if l_version is NULL"
should be
"if l_version_string is NULL"

"if none of the WHERE clauses is matched"
should be
"if none of the WHEN clauses is matched"

Remove "//" after "END;"

The comma in the final sentence does not belong:

"The prepared statement is executed with the, EXECUTE statement:"

"END$$" should be "END;"

"...set the variable p_status to ..."
should be
"...set the variable out_status to ..."

"DECLARE CONTINUE HANDER FOR"
should be
"DECLARE CONTINUE HANDLER FOR"

"...ability to display the SQLSTATE or SQLSTATE..."
should be
"...ability to display the SQLCODE or SQLSTATE..."

"implements a SQLSTATE or SQLSTATE variable"
should be
"implements a SQLCODE or SQLSTATE variable"

Should be MESSAGE_TEXT instead of MESSAGE_TEST (also in ex06-17.sql in the sample files)

END$$
should be
END;

line 33:
SET p_sqlcode=1052;
should be:
SET p_sqlcode=1062;

For consistency,
"HANDLER FOR not FOUND"
should be
"HANDLER FOR NOT FOUND"

Entry for line 53 is actually for line 63.

@p_sqlcode value is
1052
but should be
1062

"the ability to directly access the SQLSTATE or SQLSTATE variables"
should be
"the ability to directly access the SQLSTATE or SQLCODE variables"

"In the absence of a SQLSTATE or SQLCODE variable, it is good practice for you to define handlers against all error conditions [...] that populate a SQLCODE-like variable..."

Replace "that populate" with "and populate".

The book says "IF EXISTS is only valid for stored procedures
and triggers, not for triggers", which seems a bit self-contradictory.

Presumably it should say "... only valid for stored procedures and
functions, ..."

Drop 'sp_' from 'sp_location_exists'. Later reference is to 'location_exists'.

END$$ should read: END;

Function name "EXPORT_SET" should be changed to "ENCODE_SET" to match the description of the "ENCODE_SET" function in the table.

The chapter begins "In this chapter, we will tune of simple SQL statements...",
which doesn't make sense. Is "of" superfluous?

typo SUBSTRNG
should be SUBSTRING