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


This errata page lists errors outstanding in the most recent printing.  

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 last updated on April 12, 2001.


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


CONFIRMED errors:


[101] 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.