Chapter 9 - Corrections

(1 pr - for this entire first section) 
LOV Hands-On Practice, Phase V - Try Some Variations, "Add a Department Name Lookup"
p.332

There is a JDeveloper inconsistency that requires you to create the row set information before modifying the Dept entity. Therefore, the order of tasks in the bullet point list on this page should be:

o  Set up the BC4J view link
o  Modify the form
o  Modify the Dept entity

If you have not completed this section, use the order above. (You may ignore the following instructions.) Again, this is only a problem in the first printing.

If you have followed the order in the book (not the order above), you may receive an "ORA-00936: missing expression" error when you are selecting columns for the queryInfo property of the deptDetailRowSet object. If you click the Test Query button, you will see that the DNAME column is missing from the query. 

Use the following steps to fix this problem:
1. Return to the Dept entity under the DeptEmpBusCompPRJ project application module. Right click the Dept entity and select "Edit Dept" to view the properties.

2. Click the Attribute Settings tab and select the DNAME attribute from the top pulldown list.

3. Check the Persistent checkbox and the Queriable checkbox. Change the Database Column Name field to "DNAME" and the Type to "VARCHAR2(14). Click Finish.

4. Rebuild the BC4J project and click Save All.

5. You should now be able to set the queryInfo property successfully in the deptDetailRowSet. Once you have completed the steps in the "Modify the Form" part, test the form (without saving changes). After verifying that the form works, redo the steps in the "Modify the Dept Entity" part.

------------------------------------------------------------------------------

(1 pr) p.343, step 10, Add the following at the end of the paragraph: "Select the Ename value and click OK."

(1 pr) p. 353, step 1, The sentence "The latter property..." Should appear after the illustration.