Compile Issue when db packages contain procedure parameters defined as a cursor%rowtype.
Oracle Forms 12c - Compile Issue db packages containg procedure parameters defined as a cursor%rowtype.
During compilation of forms, we run into a rather specific problem.
Situation
db 12c
forms 12.2.1.2
compilation envirionment linux (redhat 7.3)
The db contains a package which is called from a form.
Typically, the db package contains definitions of procedures of which the parameters with the construct cursor%rowtype.
Program units at forms level which are calling the db package do not compile mentioning that the referenced db package does not exist.
Typically output in the .err file:
Compiling package body PackageNameInForms...
Compilation error on package body PackageNameinForms: