Thursday, August 13, 2015

How to Compile CUSTOM.pll in 11i and R12? FRM-40735: ON-ERROR trigger unhandled exception ORA-06508



Location
--------------
CUSTOM.pll is under $AU_TOP/resource


Use following Command as per your environment

For R12
frmcmp_batch module=CUSTOM.pll userid=apps/<apps_password> output_file=CUSTOM.plx module_type=LIBRARY batch=yes compile_all=special

For 11i
f60gen module=$AU_TOP/resource/CUSTOM.pll userid=apps/apps
module_type=LIBRARY module_access=FILE
compile_all=YES output_file=$AU_TOP/resource/CUSTOM.plx


Issue -     FRM-40735: ON-ERROR trigger unhandled exception ORA-06508


Cause -      CUSTOM.pll is changed or got corrupted 

Solution -
1. Change the directory to $AU_TOP/resource
2. Restore the last Working CUSTOM.pll and compile it using the above mentioned command.
3. It will generate CUSTOM.plx (Both should be under $AU_TOP/resource)
4. Retest the issue.


No comments:

Post a Comment

Oracle Database Administrator