Forms library form
489148Feb 14 2006 — edited Feb 15 2006I have to upgrade a number of forms from 4.5 up to 10g. The project has a single library form (.fmb file) with shared program units, triggers and a data block.
When I open any of the dependant forms in Forms Builder 6i I get these errors:
ORA-00942 Table or view does not exist (repeated several times)
FRM-18108 Failed to load the following objects
Source Module: AGSP_IPS
Source Object: key-enter
FRM-10043: Cannot open file
I seen a recommendation elsewhere to compile with the 'module_type=library' and 'module_access=file' but this gives the following error 'PDE-PLI011 A tools common schema table is missing from the object store'. It is obviously trying to compile into the database which isn't what I wasnt. I followed another suggestion and ran the following scripts toolbild.sql, DEBILD.SQL and DEGRNT.SQL but this didn't help.
What do I need to do to convert the 4.5 library form into a library that I can use in 6i upwards?
Thanks,
Pascal
------------------------------
Forms: 6.0.8.11.3
Oracle: 8.1.7 Linux