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.0 - PL/SQL ERROR 422

user-qttwoMay 23 2023 — edited May 25 2023

Hi,

I'm trying to compile an existing set of Oracle Forms source files with the latest version (12.2.1.19.0) of the Oracle Forms frmcmp_batch compiler for Linux.

Multiple Forms seem to be failing without any clear indication what's wrong.
They all result in the following error message during compilation:

Compiling WHEN-NEW-RECORD-INSTANCE trigger on ABCOPSLAG data block...
Compilation error on WHEN-NEW-RECORD-INSTANCE trigger on ABCOPSLAG data block:
PL/SQL ERROR 422 at line 78, column 4
no PL/SQL translation for the bindtype given for this bind variable
PL/SQL ERROR 0 at line 1, column 1
Compilation unit analysis terminated

This only seems to happen if compile_all=YES is specified as a compiler parameter.

I've tried several common tricks to circumvent the error, for example converting the fmb's to fmt and back, but the error keeps popping up, seemingly on random bind variables in the source code.

Any ideas on how to solve this? Thanks!

Comments
Post Details
Added on May 23 2023
3 comments
1,414 views