When-new-form-Instance trigger raised unhandled exception ORA-04062
554635Jan 5 2007 — edited Aug 2 2007Hi,
We are facing ORA-04062 (FRM-40735 WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA 04062) while trying to run the first form of our Application.
We are using a PL/SQL LIBRARY(.pll) for forms.
We are using 10G Application Server,10G DB and Oracle 9i Forms.
DB Version----10.1.0.4.0
Application Server--9.0.4.0
During compilation, we are following the below steps:
1. Compile the .pll
2.Compile Forms.
When we are running these compiled version of forms and pll in Development server where we are compiling it,we are not facing any error.
But when we are taking these compiled version of forms and pll to the Production Server,we are getting the above error.
When we are compiling the .pll in Production server, Application runs fine.
But we should not compile form or pll in Production server.
Searching in Metalink(Note:73506.1) , we find a solution that remote_dependency_mode if set to signature this problem may be resolved.
We tried that by chaning ' REMOTE_DEPENDENCIES_MODE=SIGNATURE' in Init.ora file in both Production and Development server.
But the error still persist.
I think the problem is regarding .pll.Because for the time being to test the application,I compiled the pll in Production and we didnot get any error while running the Application.
But whenever we are tring to deploy the compiled version of pll (compiling in Development sever) and to run the application in Production, we are facing the error.
Also, pll calls one standard database package in SYS.That standard package has VALID status both in Production and in Development.
We donot have priviledge to change/compile that package.So,we didnot change anything in that package. We didnot change anything in .pll also.
We are upgrading our forms from 6i to 9i.And now when we are trying to deploy it to Production we are facing ORA-04062 error.
Can anyone please help ?