Why won't form execute PL/SQL when built on Windows?
EDIT: I contacted Oracle Support. Evidently the generated FMX files are OS specific. I need to compile it on Linux to run it on Linux.
Forms Server environment
- Oracle Linux 7 (hostname=apollo)
- Forms & Reports 12.2.1.3
Developer Forms environment
- Windows 10 Education
- Forms & Reports 12.2.1.3
I'm trying to set it up so that developers can compile FMX files on their Windows machines then copy the resulting FMX file to the forms server (apollo). Unfortunately when we do so it doesn't run PL/SQL triggers.
The form has a WHEN-NEW-FORM-INSTANCE trigger that maximizes the form, then several buttons that launch other forms. NEither work.
When I compile the form using the frmbld on Linux it works as expected.