Errata

Oracle PL/SQL for DBAs

Errata for Oracle PL/SQL for DBAs

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 xx
the URL to the book's page

http://www.oreilly.com/catalog/plsqldba
should be:
http://www.oreilly.com/catalog/9780596005870/

Note from the Author or Editor:
On page xx, change "http://www.oreilly.com/catalog/plsqldba" to "http://www.oreilly.com/catalog/9780596005870/"

 Anonymous   
Printed
Page 4
2nd Colde block demonstrating the DECLARATION section

The following block should use data type of DATE instead of VARCHAR2(9)
as the 3rd code block explains the use of an EXCEPTION and obviously is meant to be
wrong to force the error message.

2nd Code block:
declare
l_right_now varchar2(9);
begin
l_right_now := sysdate;
dbms_output.put_line(l_right_now);
end;
/

Should be:
_admin@SCUKDEV2> declare
l_right_now DATE;
begin
l_right_now := sysdate;
dbms_output.put_line(l_right_now);
end;
/

Note from the Author or Editor:
Correct. Please change VARCHAR2(9) to DATE.

 Anonymous   
Printed
Page 78
code segment for show_parts_inventory

The test for the select statement is missing || after parts_table
current text

OPEN dyncur FOR
'SELECT * FROM ' || parts_table
'WHERE ' || where_in;

should be

OPEN dyncur FOR
'SELECT * FROM ' || parts_table ||
' WHERE ' || where_in;

 Anonymous   
Printed
Page 107
2nd paragraph in the Tips section

The code sample in the tips shows:

DECLARE
TYPE v_curs_t is REF_CURSOR;
v_curs v_curs_t;

This should be:

DECLARE
TYPE v_curs_t is REF CURSOR;
v_curs v_curs_t;

Note, there is no "_" between REF and CURSOR.

Note from the Author or Editor:
Correct. Please change REF_CURSOR to REF CURSOR.

 Anonymous   
Printed
Page 239
PL/SQL Example

As far as I'm concerned, the l_str variable gets overridden all the time instead of being concatenated. So the function allowed_enames always returns 'ENAME IN )'.

Note from the Author or Editor:
replace "l_str :=" by "l_str := l_str||"

 Anonymous