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.
| Version |
Location |
Description |
Submitted By |
Date Submitted |
Date Corrected |
| Printed |
Page 11
line 3: "capture" is now in bold constant-width font |
|
Anonymous |
|
Dec 01, 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 01, 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 01, 1998 |
| Printed |
Page 21
para. 4, line 5 and line -1: both occurances of "DMBS" now read "DBMS" |
|
Anonymous |
|
Dec 01, 1998 |
| Printed |
Page 27
line -7 |
"Provide a salary that does this"
now reads
"Provide a procedure that does this"
|
Anonymous |
|
Dec 01, 1998 |
| Printed |
Page 33
First 2 code examples |
First lines of both did read:
PACKAGE config
now reads:
PACKAGE BODY config
|
Anonymous |
|
Feb 01, 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 01, 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 01, 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 01, 1998 |
| Printed |
Page 189
the heading "PLV1st: List Mananger": "Mananger" now reads "Manager" |
|
Anonymous |
|
Dec 01, 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 01, 1999 |
| Printed |
Page 338
Table 13-1, row 3 |
"UTL_FILE.INVALID_FILE-HANDLE"
now reads
"UTL_FILE.INVALID_FILE_HANDLE"
|
Anonymous |
|
Dec 01, 1998 |
| Printed |
Page 338
|
Table 13-1, row 3: "UTL_FILE.INVALID_FILE-HANDLE" now reads:
"UTL_FILE.INVALID_FILE_HANDLE"
|
Anonymous |
|
May 01, 1999 |
| Printed |
Page 379
code sample 1, line 6 |
"display_line(line_ind)"
now reads
"disp_line(line_ind)"
|
Anonymous |
|
Dec 01, 1998 |
| Printed |
Page 379
|
code sample 1, line 6: "display_line(line_ind)" now reads:
"disp_line(line_ind)"
|
Anonymous |
|
May 01, 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 01, 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 01, 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 01, 1998 |
| Printed |
Page 544
para. 3, line -2, "...inside an IF statement in PLVcmt" |
"PLVcmt" now reads "PLVlog"
|
Anonymous |
|
Dec 01, 1998 |
| Printed |
Page 561
code sample 2, line 1 |
SQL> execute PLVlog.to_pstab
now reads:
SQL> execute PLVlog.to_dbtab
|
Anonymous |
|
May 01, 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 01, 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 01, 1998 |
