Re: Oracle Forms Security

FORMS 3 and FORMS4.5 work consistently with regard to KEY-EXIT and KEY-COMMIT.
Whenever an Oracle dialog box is presented to give the user the option of saving,
exiting the form, etc. Oracle does not fire the corresponding KEY-COMMIT and
KEY-EXIT triggers. This is a long-standing problem.

Further, if you convert to Windows environment and the user clicks with the mouse
to navigate, the usual KEY-xxxx triggers don't fire either.

The KEY-EXIT and KEY-COMMIT problem has no known solution; you simply cannot
put business rules in these triggers and trust that they will fire in any circumstance. For Windows, learn to use PRE, POST, and WHEN triggers to implement
business rules.

Al Lawson
Interactive Group, Inc.
www.interactive-group.com
lawsona_at_interactive-group.com Received on Sat Jul 12 1997 - 00:00:00 CDT