Chapter 6, p 195, items 3 through 8. I changed the default error message and the new message only appears when I log into the application and select the Purchases by Customer tab with the % in the Customers drop down list. Otherwise I get the "old" default error message from Figure 6-27. Any clues as to why the new error message isn't appearing other than at first access after application login?

After looking at the debugger statements and after playing with the query returning the data for the Flash Chart, I realized that if the query truly found no records then the appropriate error message was displayed. I edited the Null Return Value of the Pn_CUSTOMERS list of values to 99999 (a CUSTOMER_NAME_ID that will hopefully never exist) and the appropriate message is now being displayed when choosing the "wildcard" value from the Customer dropdown list.

Given the fact that the book assumes the error message worked appropriately without having to make other changes, I'm concerned that I had to figure this out and now I'm wondering if I screwed up somewhere along the line when doing the tutorials in Chapter 6 (or earlier!).

hi this is Hedward Marsh, i am beginner to oracle i am searching for oracle based questions and errors and solutions i found this website in this website i found very useful information thanks for posting job description