Hello to all,
I'm migrating my forms 6i to 11g. My problem is that every single form has an error when loading. The error is "FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508." In the beginning there were more errors and by converting all forms and libraries and then compiling them, i was able to clear all the errors. But this one isn't going away. I compile the forms and everyting is fine. So could it really be some program unit that is missing? Just to tell, with a form created is forms 11g the error don't show up. What can it be?
Edited by: user12231131 on 5/Jan/2011 8:16
I compile in Forms builder and it's successful. Only in runtime it displays the error. After bumping my head to the wall, i discover that if i remove the trigger WHEN-NEW-FORM-INSTANCE he loads correctly but the same error displays whenever i do something else. Could it be that all triggers are shooting this error? Maybe i could try to copy an entire form to a new one created firsthand in 11g and see if it still gives the error no?
Information: I have my forms 6i all built in windows, and i am now builting my 11g in linux. To convert them i use frmplsqlconv and then frmcmp to compile them.
Please have your DBA follow the steps below:
1. Close the session
2. Clear off memory to resolve the error ORA errors.
3. Recompile all libraries and forms.
4. Restart new session for the application and retry the issue.