Advanced Oracle PL/SQL Programming with Packages

Errata for Advanced Oracle PL/SQL Programming with Packages

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