May 18, 2017

Forms Application shows a 'FRM-40735: WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508' after upgrade to 11.1.2.2.0

Situation:

After an upgrade from 11.1.2.1.0 to 11.1.2.2.0 and a patch apply of patch 19933795 (see post Forms Application does not run anymore after java upgrade to 1.8_131 on client), the application shows an 'FRM-40735: WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06508':



Solution:

I had to recreate the webutil repository (create_webutil_db.sql) and to recompile webutil.pll. After that, the application runs fine again ...

Important!!: Compile webutil.pll in your FORMS_HOME path and leave the webutil.plx there. In case of a different FORMS_PATH for an application, simply copy webutil.pll and webutil.plx to that path. Interestingly, the webutil.plx is expected in FORMS_HOME, even if webutil paths are set to an application specific path ...

Share:

0 comments:

Post a Comment

Copyright © Robert Crames' Oracle Database and Middleware Blog | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by NewBloggerThemes.com