Errata

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.

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.

First lines of both did read:

PACKAGE config

now reads:

PACKAGE BODY config

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

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

__________________________________________

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

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

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

"UTL_FILE.INVALID_FILE_HANDLE"

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

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

"disp_line(line_ind)"

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

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

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

"PLVcmt" now reads "PLVlog"

SQL> execute PLVlog.to_pstab

now reads:

SQL> execute PLVlog.to_dbtab