Oracle PL/SQL Programming: Guide to Oracle 8i Features
by Steven Feuerstein


Unconfirmed error reports are from readers. They have not yet been 
approved or disproved by the author or editor and represent solely the
opinion of the reader.

If you have any error reports or technical questions, you can send them to
booktech@oreilly.com. (Please specify the printing date of your copy.)


This page was updated May 16, 2002


Here's a key to the markup:

        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification


UNCONFIRMED errors and comments from readers:


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


(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


[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