Oracle Form Error FRM-40735 when Adding Student Course
|
|
Web application is the preferred way of entering data in our work place. But, Oracle Client Server Application is still used by our Registry Office to enter some information in some cases. Late enrollment for example requires manual registration of students into the system.
An error - FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-00904 - was thrown when a new student was registered to a course of the previous semester. This prompted me to investigate the cause. Checking the WHEN-VALIDATE-ITEM trigger of the Data Block items have revealed an error when compiled.
|
|
In the past days we have some review of our slow performing views. As a result, we have changed the view and this has caused the error ORA-00904 when the form could not find the data field used. After changing the form to point to the correct data source have corrected the error upon compilation.
The form error - FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-00904 - was gone when the client server application was run.
Posted on
Monday, January 26th, 2009 at 6:32 pm under 