Oracle Application Server 10g also includes Forms 9i. While Banner® 7 will deliver all fmbs in this format, any custom "in-house" forms sources (FMB) will need to be converted from Forms 6i->9i.
Prior converting forms perform the following:
1. Verify that all forms to be converted DO NOT have program units saved in the database. Previous versions of Oracle Developer allowed code to be saved in the database. Started with Forms 9i, this will not be allowed. All program unit MUST be saved into the form source.
2. Set the environment variable $FORMS90_PATH to point to the directory containing all form libraries.
Oracle delivers a script to handle this conversion automatically, this is called f90plsqlconv.sh and is located in the 10gAS $ORACLE_HOME/bin directory.
There are two parameters that need to be passed to this script. They are:
1. module/form name
2. database login (username/password@DB_STRING)
Running this script w/o any arguments will produce the following help screen:
$ f90plsqlconv.sh
ERROR: No valid files specified for processing.
Oracle9i Forms Migration Assistant version 9.0.4.0
Copyright(c) 2001, 2003, Oracle. All rights reserved.
Usage: /u01/app/oracle/product/ias_10g/bin/f90plsqlconv.sh mode=wizard
or
/u01/app/oracle/product/ias_10g/bin/f90plsqlconv.sh
module=module_name userid=username/password [log=logfile]
where:
mode Run the converter using the wizard (mode=wizard)
username/password The database connection information
module_name The name of the module to be processed
logfile The log file name
Note: When running in wizard Mode the module_name, username,
password, and logfile arguments are ignored
However, BE WARNED THAT THIS HELP SCREEN IS WRONG.
THE NAME OF THE FORM TO BE CONVERTED MUST BE SPECIFIED BY A
MODULE= INSTEAD OF A MODULE_NAME= TAG.
THE DATABASE USER MUST BE SPECIFIED BY A
USERID= INSTEAD OF A USERNAME= TAG.
In most cases the conversion should done as the baninst1 user.
For example, to convert a form called GUATEST.fmb connecting to the SEED7 database you would run the following:
$ f90plsqlconv.sh module=GUATEST.fmb userid=baninst1/u_pick_it@SEED7
Note that the conversion will modify the original form. So prior to running this step, be sure that all form sources are backed up.
Once this conversion is done, the form is ready to be compiled!
