Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
frmxml2f.bat conversion error
Hi,
In my project, we have decided to convert all the FMBs to XML and save them in source code repository.
In this conversion process, I'm facing an error while converting XML to FMB. I have followed the below procedure to convert FMB to and from XML.
- Converted all FMBs to XML using frmf2xml.bat and didn't faced any issues while converting.
- frmf2xml.bat overwrite=yes *.fmb
- Decided to convert all XMLs generated above to FMB to check the functionality whether it is same or not by using frmxml2f.bat.
- frmxml2f.bat overwrite=yes *.xml
- During the conversion from XML to FMBs some files are giving a pop-up with message as "The program unit XXXXXX is already exist. Do you want to continue ?" and not sure why it is giving such kind of errors and those program units were sub-classed in objects group from parent object such as pll.
Attaching error message here. Can anyone suggest me, why it is showing such pop-up messages and what could be the reason for it ?
Regards,
Srinivas Makkina
Answers
-
Exactly which Forms version are you using? If you are using 12.2.1.4, trying doing the same directly from within the Builder. However, you will only be able to convert one file at a time in the Builder.
-
Hi Michael,
I am using 11g forms. I am aware that, we can convert files from birany-text-binary from forms builder as well and we can do only one file at a time.
To simplify the process and for time saving, we used '.bat' files which came along with forms installer to convert all the files at a time.
Regards,
Srinivas Makkina
-
@User_PNQ92 Please re-read what I said. These were my two questions/comments:
- Exactly which Forms version are you using? "11g" is not a version, it is a product name. When posting it is very important that you share the exact version number so we can reply with accurate information as it applies to the version you are using.
- You said, "... I am aware that, we can convert files from birany-text-binary from forms builder...". I was not referring to the fact that you can convert to/from binary. I was referring to the fact that you can convert to/from XML in the Builder IF you are using the latest version (e.g. 12.2.1.4).
I would recommend you attempt to convert a single module (one that includes sub-classing) using the utility provided in the installation. Do not run it from a custom script. If this works, likely there is an issue with your script. If it does not work, there may be an issue with the version you are using. This might be a good time to consider upgrading to a supported version, like 12.2.1.4. Continuing to use desupported software versions may put your system at risk, as well as leave you troubled with old bugs that have since been corrected.
-
Hi Michael
Is there a way to handle CI CD deployment for Oracle Forms? I am facing the same issue as mentioned in this thread
During the conversion from XML to FMBs some files are giving a pop-up with message as "The program unit XXXXXX is already exist. Do you want to continue ?"
The Client uses the latest version of Oracle Forms 12. Using the utility tool with batch file I am trying to convert .fmb to xml and xml to .fmb file.
But I find issue only with xml to .fmb file conversion.
Thanks in advance
Ramesh Ram
-
The duplicate PU dialog occurs when a PU is stored in an Object Library then sub-classed. You can avoid the dialog by copying rather than sub-classing or do not store the PU in the OLB. Instead create a PLL.
OLBs are really intended for storing objects and not extensive code like what is found in a PU. Although it is technically possible to store PUs in an OLB, it is not recommended.
That said, for the next release we are planning to determine if a way to force an answer for the dialog can be exposed. But again storing PUs in an OLB isn’t a good idea. Re-usable plsql should be in a PLL
