Oracle Forms Upgrade: Compiling a 12c Form Results in "Error 801 Internal Error Unexpected fragile
Oracle Forms Upgrade - Compiling a 12c Form Results in "Error 801 Internal Error Unexpected fragile external reference"
Titleimage
Posted by RENAPS DBA Team on 2024:07:05 18:41:03
Oracle Forms - Applies To
Oracle Forms - Version 12.2.1.3.0 and later
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.
Oracle Forms Symptoms
When attempting to compile a form in Forms 12c, the following error occurs:
Error 801 at line1, column 1 Internal error [Unexpected fragile external reference.]
The error occurs when inside a package body, defined in the form module, a program unit opens a cursor defined in its package specification.
The same form module compiles successfully in Oracle Forms 11g and 10g.
Oracle Forms Changes
The upgrade of Oracle Forms from version 10gR2 to version 12c has been completed.
Cause
This is due to:
Bug 22201736 - UNABLE TO COMPILE FORM MODULE IN ORACLE FORMS 12C
Solution
Solution is to set the following before compiling:
FORMS_PLSQL_BHVR_COMMON_SQL=1
Setting the same for runtime (e.g. default.env) will also be necessary.
IMPORTANT: It should be noted that a side effect of enabling FORMS_PLSQL_BHVR_COMMON_SQL is that calls to COMMIT may need to be replaced with COMMIT_FORM and calls to ROLLBACK will need to be replaced with CLEAR_FORM. As of Forms 11.1.2, the Forms Migration Assistant (FMA) has been enhanced to perform a Search/Replace operation for these terms. This change should help to make the upgrade process easier.
Oracle Forms Upgrade: Automate your Oracle Forms Upgrade process with ORMIT™-Forms
ORMIT™-Forms automates every Oracle Forms Upgrade from all earlier versions to the latest versions.
ORMIT™-Forms guarantees the overall success of your Oracle Forms Upgrade with an emphasis on efficiency, cost and time savings, eliminating any potential risk. The automated process is extremely fast and secure. It automates a large quantity of actions while eliminating the guess work associated with manual upgrades. ORMIT™-Forms also minimizes downtime and identifies manual tasks that require DBA action.
Posted by RENAPS DBA Team on 2024:07:05 18:41:03