Oracle Forms (MOSC)

MOSC Banner

Why won't form execute PL/SQL when built on Windows?

edited Jun 9, 2021 5:37PM in Oracle Forms (MOSC) 1 commentAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center