My Oracle Support Banner

Oracle FADS (Forms Application Deployment Services) Fails To Compile Forms Containing Procedures (Doc ID 3073018.1)

Last updated on FEBRUARY 25, 2025

Applies to:

Oracle Forms - Version 14.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

On : Oracle Forms 14.1.2.0.0 version
Oracle FADS (Forms Application Deployment Services) fails to compile forms with procedures

the following error occurs during compilation.

ERROR
-----------------------

Compilation error on procedure EXECUTE_DETAIL_QUERY...
Compilation error on procedure EXECUTE_DETAIL_QUERY:
PL/SQL ERROR 202 at line 142, column 8
identifier '<PROCEDURE-NAME>' must be declared
PL/SQL ERROR 0 at line 142
Statement ignored

The above is a Procedure in an attached library.



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.