Errata

Oracle PL/SQL Programming: A Developer's Workbook

Errata for Oracle PL/SQL Programming: A Developer's Workbook

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 129
Problem 16-16

Change:

"...database schema if she has..."

to:

"...database schema if the user has..."

Anonymous    Sep 01, 2000
Printed
Page 129
Part b of Problem 16-16

Change:

"...if she has the CREATE..."

to:

"...if the user has the CREATE..."

Anonymous    Sep 01, 2000
Printed
Page 131
Part b of Problem 16-24

Change:

"...granted directly from the user..."

to:

"...granted directly to the user..."

Anonymous    Sep 01, 2000
Printed
Page 244
IN PRINT: Item 1-12

"...can have only one of three values: -1, 1, or NULL."

SHOULD BE:
"...can have only one of four values: -1, 1, 0, or NULL."

 Anonymous   
Printed
Page 263
The third line of code in example 4-18

Change:

"exception unknown_sex;"

to:

"unknown_sex EXCEPTION;"


 Anonymous    Sep 01, 2000
Printed
Page 269
Solution for 4-36

it should say:

The correct answer is (c). After the first NO_DATA_FOUND is re-raised,
control is passed immediately to the outer block's exception section and then
the string displayed terminates with "No data in outer block". Following this,
PL/SQL does not return to the block to finish up by displaying "Finished test".

 Anonymous   
Printed
Page 287
Part c of Solution 6-5

Change:

"c. True. Index-by tables cannot be saved in the database..."

to:

"c. False. Index-by tables cannot be saved in the database..."

 Anonymous    Sep 01, 2000
Printed
Page 293
Solution 6-22

Change:

the_table (NVL (the_table.FIRST, 0) + 1) := 2067;

to:

the_table (NVL (the_table.LAST, 0) + 1):= 2067;

 Anonymous    Sep 01, 2000
Printed
Page 373
The first sentence

Change:

"The function make three inappropriate..."

to:

"The function makes three inappropriate..."

 Anonymous   
Printed
Page 398
Part d of Solution 16-2

Change:

"You can create..."

to:

"Oracle8i allows you to create..."

Anonymous    Sep 01, 2000
Printed
Page 401
Part d of Solution 16-17

Change:

"...created on NESTED TABLE..."

to:

"...created on the NESTED TABLE..."

 Anonymous   
Printed
Page 401
Part c of Solution 16-17

Change:

"False. Oracle8..."

to:

"True. Oracle8..."

 Anonymous    Sep 01, 2000
Printed
Page 401
Part d of Solution 16-17

Change:

"Oracle8i introduced..."

to:

"True. Oracle8i introduced..."

 Anonymous    Sep 01, 2000
Printed
Page 403
Solution 16-24

Change:

"...granted directly by the owner..."

to:

"...granted directly to the trigger owner..."

 Anonymous    Sep 01, 2000
Printed
Page 545
The answer to question 29-9

Change:

"(e). You can use the DBMS_SESSION package to keep..."

to:

"(d). You can use the DBMS_SHARED_POOL package (using the KEEP
procedure) to keep..."

Anonymous    Sep 01, 2000