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 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.
|
Anonymous |
|
Printed |
Page 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.
|
Anonymous |
|
Printed |
Page 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".
|
Anonymous |
|
Printed |
Page 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".
|
Anonymous |
|