Problem Description:
Problem Description:
====================
Are Version 2.0 (V2) style triggers supported in Oracle Forms 4.X and 5.0?
Problem Explanation:
====================
How does the Forms upgrade process handle V2 style trigger conversions? Will
the V2 style triggers still work in Forms 4.X and 5.0, or will I have to
rewrite the code in PL/SQL?
Solution Description:
=====================
Third-party migration tools exist to convert SQL*Forms 3.0 to Oracle Forms,
including converting V2 style triggers to PL/SQL. Sierra Atlantic and Kumaran
Systems are part of the Oracle Open Tools Initiative (OTI), and have migration
tools available.
Sierra Atlantic
---------------
Sierrra Atlantic FormsGenie is an automated migration tool that will upgrade
SQL*Forms 3.0 applications to Developer/2000, and convert your V2 style
triggers to PL/SQL.
Web: http://www.SierraAtl.com
Email: FormsGenie@SierraAtl.com
Americas and Japan
------------------
Sierra Atlantic Inc.
830 Hillview Court, Suite 110
Milipitas, CA 95035 USA
Phone (408)956-3000
FAX (408) 956-3001
Europe, Middle East, Africa
---------------------------
Sierra Atlantic, UK
Phone 44-115-922-8600
FAX 44-115-922-5550
Asia-Pacific
------------
Sierra Optima Limited
Phone 91-40-3740-368, 3746122
FAX 91-40-3746419
Kumaran Systems
---------------
Kumaran Systems GUI*Converter is an automated migration tool that will upgrade
SQL*Forms 3.0 applications to Developer/2000. The Forms Converter will
convert your V2 style triggers to PL/SQL.
Web: http://www.kumaran.com
Worldwide Headquarters
Kumaran Systems, Inc.
701 Evans Avenue, Suite 509
Toronto, Ontario
Canada, M9C 1A3
Phone: 1-800-586-2726
(416) 626-1332 (Toronto)
United States Offices
12300 Twin Brooks Parkway, Suite 660
Rockville, Maryland
USA, 20852
Phone: 1-800-586-2726
Solution Explanation:
=====================
The Oracle Forms generator will not convert V2 style triggers to PL/SQL, but
there are third party products available that have this functionality.
See the "Oracle Open Tools Initiative" CD included with Developer/2000 for
more information on companies involved in the Oracle Open Tools Initiative.
V2 STYLE TRIGGERS RUN BUT ARE NOT CONVERTED TO PL/SQL
Solution Description:
=====================
If you convert a form that contains Version 2.0 style triggers, they will
still run in Developer/2000 Release 1.X and 2.0. You can view these triggers,
but you cannot edit or modify them.
The Oracle Forms Generator does not convert V2 style triggers into PL/SQL
triggers. During conversion, Oracle Forms copies the text of your triggers
verbatim. V2 style triggers remain V2 style triggers, and V3 style PL/SQL
triggers remain PL/SQL triggers.
If you want to edit the V2 style trigger, you must manually convert the
trigger to PL/SQL. There is no automatic mechanism to convert the V2 style
trigger to PL/SQL.
Some trigger names specific to SQL*Forms 2.3 / 3.0 are changed to Oracle Forms
nomenclature, but the TEXT of the triggers is NOT changed in any way. For
example, an On-Validate-Field trigger would be renamed to a When-Validate-Item
trigger, but the text of the trigger remains the same.
Solution Explanation:
=====================
SQL*Forms 2.3 used Version 2.0 style triggers, and did not use PL/SQL. V2
style trigger support is included only for backward compatibility with earlier
versions of Forms. All V2 style triggers should be converted to PL/SQL.