Thanks for the reply.

Started working on chapter 4 this afternoon and found this gem on page 83 about savepoints.

""After the savepoint is set, you can roll back to that point by including the TO operator and the name of the savepoint. After you issue a ROLLBACK TO statement, all DML statements before the savepoint are committed and all changes after the savepoint are rolled back ..... continues"

What a load of bullpap.

From Oracle's documentation:

Using ROLLBACK with the TO SAVEPOINT clause performs the following operations:

Rolls back just the portion of the transaction after the savepoint.

Erases all savepoints created after that savepoint. The named savepoint is retained, so you can roll back to the same savepoint multiple times. Prior savepoints are also retained.

Releases all table and row locks acquired since the savepoint. Other transactions that have requested access to rows locked after the savepoint must continue to wait until the transaction is committed or rolled back. Other transactions that have not already requested the rows can request and access the rows immediately."


The guys who wrote this book are all fully OCP'd so I am worried if claring errors like this have been found in the 1st few chapters what's the point on continuing with this book.

I think I'll source a Sybex book on the Oracle 10g OCP.