The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
| Version |
Location |
Description |
Submitted by |
Date submitted |
| Printed |
Page 91
Code block at top of page |
Select statement is
SELECT <snip>
FROM <snip>
BULK COLLECT INTO <snip>
etc.
BULK COLLECT INTO should be before FROM, not after.
|
Anonymous |
|
| Printed |
Page 193
code sample at bottom |
This code sample block calls "p.l". It should call "pl".
[204 and disk] xfile.pkg;
xfile does not compile.
I believe it is missing a comma for fopen. Here is the original compile error:
Errors for PACKAGE BODY XFILE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
300/7 PLS-00103: Encountered the symbol "MAXLINESIZE" when expecting
one of the following:
:= . ) , @ % default character
The symbol "," was substituted for "MAXLINESIZE" to continue.
When I add the alleged missing comma I get another error as follows:
Errors for PACKAGE BODY XFILE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
75/13 PLS-00323: subprogram or cursor 'FOPEN' is declared in a package
specification and must be defined in the package body
|
Anonymous |
|
| Printed |
Page 235
Attached Disk - PLVtmr.pkg |
On installing the PLVtmr.pkg
Got compile errors.
LINE/COL ERROR
-------- -----------------------------------------------------------------
16/10 PL/SQL: Item ignored
16/19 PLS-00201: identifier 'PLV.IDENTIFIER' must be declared
22/17 PLS-00201: identifier 'PLV.DBMAXVC2' must be declared
22/17 PL/SQL: Item ignored
56/7 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
56/7 PL/SQL: Statement ignored
81/14 PLS-00201: identifier 'PLV.DBMAXVC2' must be declared
81/14 PL/SQL: Item ignored
100/17 PLS-00201: identifier 'PLV.DBMAXVC2' must be declared
100/17 PL/SQL: Item ignored
104/12 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
104/12 PL/SQL: Statement ignored
107/10 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
107/10 PL/SQL: Statement ignored
114/13 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
|
Anonymous |
|