Errata


Print Print Icon

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 "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



Version Location Description Submitted By Corrected
Printed Page 11
line 3: "capture" is now in bold constant-width font

Anonymous  Dec 1998
Printed Page 12
1st para. under "Referencing Package Elements" is new

A package "owns" its elements, just as a table owns its columns. An
individual element of a package only makes sense, in fact, in the
context of the package. Consequently, you use the same dot notation
employed in "table.column" syntax for "package.element". Let's take a
look at this practice by calling elements of the pets_r_us package.

Anonymous  Feb 1998
Printed Page 12
1st para. under "Referencing Package Elements" is new

A package "owns" its elements, just as a table owns its columns. An
individual element of a package only makes sense, in fact, in the
context of the package. Consequently, you use the same dot notation
employed in "table.column" syntax for "package.element". Let's take a
look at this practice by calling elements of the pets_r_us package.

Anonymous  Mar 1998
Printed Page 21
para. 4, line 5 and line -1: both occurances of "DMBS" now read "DBMS"

Anonymous  Dec 1998
Printed Page 27
line -7

"Provide a salary that does this"
now reads
"Provide a procedure that does this"

Anonymous  Dec 1998
Printed Page 33
First 2 code examples

First lines of both did read:

PACKAGE config

now reads:

PACKAGE BODY config

Anonymous  Feb 2000
Printed Page 85
line 2: "a hour of debugging" should be "an hour of debugging"

Anonymous 
Printed Page 98
para. 7: before "I then changed my hard-coded ..." added the

following:

"I decided to use 100 because my identifier variable needed to hold
identifiers of the form "package.element" and so that I had some
extra space with which to work."

Anonymous  May 1999
Printed Page 153
under the subheading "PL/Vision constants"

dbtab CONSTANT VARCHAR2(2) := 'DB' ;

now reads

dbtab CONSTANT VARCHAR2(2) := 'DB' ;

(removed the extra space before the semi-colon)

Anonymous  Dec 1998
Printed Page 167
para. -2: added the following sentence to the beginning of the paragraph

under "max_line VARCHAR2(1000)":

"I had to "hard code" the 1000 again in this declaration because you
must supply a literal when you declare a length for a VARCHAR2 string."

("literal" is in italics.)

Anonymous  Dec 1998
Printed Page 189
the heading "PLV1st: List Mananger": "Mananger" now reads "Manager"

Anonymous  Dec 1998
Printed Page 233
code sample 2 now reads the following

__________________________________________

SQL> SELECT PLV.now from DUAL;
__________________________________________

August 3, 1996 20:19:35

SQL> exec p.1(PLV.now);
August 3, 1996 20:20:48

(replaced the line with "NOW" and the blank line following it with a
line of dashes.)

Anonymous  May 1999
Printed Page 338
Table 13-1, row 3

"UTL_FILE.INVALID_FILE-HANDLE"
now reads
"UTL_FILE.INVALID_FILE_HANDLE"

Anonymous  Dec 1998
Printed Page 338

Table 13-1, row 3: "UTL_FILE.INVALID_FILE-HANDLE" now reads:

"UTL_FILE.INVALID_FILE_HANDLE"

Anonymous  May 1999
Printed Page 379
code sample 1, line 6

"display_line(line_ind)"
now reads
"disp_line(line_ind)"

Anonymous  Dec 1998
Printed Page 379

code sample 1, line 6: "display_line(line_ind)" now reads:

"disp_line(line_ind)"

Anonymous  May 1999
Printed Page 413

Table 16-1, cloumn 3 ("Description"): row 1 now reads:

"Sets and retrieves the current string used as the author in a
program header. The default is NULL."

("NULL" is in constant width.)

and in the same column, row 2 now reads:

"Set and retrieve the two types of indentation: initial and
incremental. The default for indent is 0 and for incremental is 3."

Anonymous  Dec 1998
Printed Page 480
last para. before heading: changed "the rows will have been

written to PLVrfrnc" to "the rows will have been written to PLVctlg"

Anonymous  Feb 1998
Printed Page 480
last para. before heading: changed "the rows will have been

written to PLVrfrnc" to "the rows will have been written to PLVctlg"

Anonymous  Mar 1998
Printed Page 544
para. 3, line -2, "...inside an IF statement in PLVcmt"

"PLVcmt" now reads "PLVlog"

Anonymous  Dec 1998
Printed Page 561
code sample 2, line 1

SQL> execute PLVlog.to_pstab

now reads:

SQL> execute PLVlog.to_dbtab

Anonymous  May 1999
Printed Page 664
added the following to the next-to-last para.

Whenever possible, our books use RepKover (tm), a durable and flexible
lay-flat binding. If the page count exceeds RepKover's limit, perfect
binding is used.

Anonymous  Feb 1998
Printed Page 664
added the following to the next-to-last para.

Whenever possible, our books use RepKover (tm), a durable and flexible
lay-flat binding. If the page count exceeds RepKover's limit, perfect
binding is used.

Anonymous  Mar 1998