Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Forms 12.2.1.19 / ORA-06508 PL/SQL could not find program unit being called at runtime

Hello everyone. I share with you the problem we are having with a client.
OS: Red Hat Enterprise Linux 8
Oracle Forms&Reports: 12.2.1.19
About 2500 Forms objects, 50 PLLs, 3 OLbs, and 20 Menus.
Webutil version used: the one included with Oracle Forms&Reports 12.2.1.19

Everything compiled Ok. But at runtime, some menus and many Forms are throwing ORA 06508: PL/SQL could not find program unit being called. After many tests on a reduced set (3 menus and 4 Forms), it was found that altering the position of the PLLs attached to the forms or reports makes the execution correct.

The main problem is that we do not find a logic in how to change the order, and since the number of Oracle Forms is so large, even using automation through JDAPI it is impossible for us to detect which combination causes the ORA 6508 error not to appear. Does anyone have any recommendations? Thank you very much in advance.

Comments
Post Details
Added on Oct 29 2024
13 comments
1,117 views