Oracle PL/SQL Programming: Guide to Oracle8i Featu

Errata for Oracle PL/SQL Programming: Guide to Oracle8i Featu

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

The following information was added to the preface: "How to Contact Us We have tested and verified the information in this book to the best of our ability, but you may find that features have changed (or even that we have made mistakes!). Please let us know about any errors you find, as well as your suggestions for future editions, by writing to: O'Reilly & Associates, Inc. 101 Morris Street Sebastopol, CA 95472 1-800-998-9938 (in the U.S. or Canada) 1-707-829-0515 (international/local) 1-707-829-0104 (FAX) You can also send us messages electronically. To be put on the mailing list or request a catalog, send email to: info@oreilly.com To ask technical questions or comment on the book, send email to: bookquestions@oreilly.com We have a web site for the book, where we'll list examples, errata, and any plans for future editions. You can access this page at: http://www.oreilly.com/catalog/9781565926752/ For more information about this book and others, see the O'Reilly web site: http://www.oreilly.com"

Anonymous    Jan 01, 2000
Printed
Page 37
Last sentence

Change: "...privileges and roles..." to: "...directly-granted privileges..."

Anonymous    Jan 01, 2000
Printed
Page 39
second bulleted item

The second bulleted item was, unfortunately, completely wrong. It now reads: "The invoker rights model checks the directly-granted privileges assigned to the invoker at the time of program execution to resolve any external references to database objects (but not PL/SQL program units). Even with invoker rights, however, roles are ignored."

Anonymous    Jan 01, 2000
Printed
Page 101
The results are as follows...

Replace the text after the paragraph beginning "The results are as follows..." with the following text: Single row fetch 10000 Elapsed: .37 seconds. BULK COLLECT 10000 Elapsed: .05 seconds. Single row fetch 100000 Elapsed: 4.1 seconds. BULK COLLECT 100000 Elapsed: .64 seconds. Single row fetch 200000 Elapsed: 9.82 seconds. BULK COLLECT 200000 Elapsed: 1.27 seconds. Single row fetch 1000000 Elapsed: 46.8 seconds. BULK COLLECT 1000000 Elapsed: 8.99 seconds. Again, we see significant improvements in performance. Notice, however, that the elapsed time difference between row-by-row fetches and BULK COLLECT diminishes as the number of rows processed grows. This undoubtedly has to do with the overhead of caching large volumes of data before passing them back to the calling program.

Anonymous   
Printed
Page 226
bulleted list at the top of the page

The following item has been added to the bulleted list at the top of the page: "* The trim_char may consist of only a single character." Also, all references to "trim_chars" in the section "The TRIM Funtion" on pages 225-226 have been changed to "trim_char."

Anonymous    Oct 01, 2000
Printed
Page 226
code sample

The code sample on this page did read: ***************** DECLARE mystr VARCHAR2(10); yourstr VARCHAR2(10) := 'Toronto'; BEGIN DBMS_OUTPUT.PUT_LINE ( TRIM (LEADING 'x' FROM 'xyzabc')); DBMS_OUTPUT.PUT_LINE ( TRIM (TRAILING 'cb' FROM 'xyzabc')); DBMS_OUTPUT.PUT_LINE ( TRIM (BOTH 'x1' FROM '1x1yzabc111x')); DBMS_OUTPUT.PUT_LINE ( TRIM ('x1' FROM '1x1yzabc111x')); DBMS_OUTPUT.PUT_LINE ( TRIM (mystr FROM yourstr)); END; / ***************** Now reads: ***************** DECLARE mystr VARCHAR2(10); yourstr VARCHAR2(10) := 'Toronto'; BEGIN DBMS_OUTPUT.PUT_LINE ( TRIM (LEADING 'x' FROM 'xyzabc')); DBMS_OUTPUT.PUT_LINE ( TRIM (TRAILING 'c' FROM 'xyzabcccc')); DBMS_OUTPUT.PUT_LINE ( TRIM (BOTH 'x' FROM 'x1yzabc111x')); DBMS_OUTPUT.PUT_LINE ( NVL (TRIM (mystr FROM yourstr), 'NULL')); END; / *****************

Anonymous    Oct 01, 2000