Oracle PL/SQL Language Pocket Reference by Steven Feuerstein, Bill Pribyl & Chip Dawes The 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. Here's a key to the markup: [page-number]: serious technical mistake {page-number}: minor technical mistake : important language/formatting problem (page-number): language change or minor formatting problem ?page-number?: reader question or request for clarification This page was updated March 31, 2005. UNCONFIRMED errors and comments from readers: {20} "Constants" section, syntax example; "CONSTANT" keyword is placed *after* the datatype, but should be placed *before* the datatype. Supporting reference: "Oracle PL/SQL Programming" 3rd ed., pg 161, "Declaring Constants" section, syntax example. [113] 1st paragraph; The introductory paragraph about bulk binds states: "Collections of records cannot be a target of a BULK COLLECT INTO clause." This is false as of version 9 release 2. From the PL/SQL User's Guide and Reference (of 10g): "When you query all the columns of a table, you can store the entire result set in a collection of records, which makes it convenient to loop through the results and refer to different columns: SELECT * FROM employees BULK COLLECT INTO all_employees; FOR i IN all_employees.FIRST .. all_employees.LAST LOOP ... END LOOP;" See also http://www.oreillynet.com/pub/a/network/2003/04/22/feuerstein.html and search for "populate a single associative array of records".