***    
<a name="top"></a>2020.08.17  
**Top**.....[Instalac 18c XE - see other txt](/fwphp/glomodul/mkd/?edit=01/001_db/01_oracle_DB_18c_instalac.txt).....[Instalac APEX 20.1](#instapex).....[Conv. 6i to APEX (Devsuite10g on WinXP)](#f6i_to_apex)


<br /><br /><br /><a name="instapex"></a>
[Top](#top).....**Instalac APEX 20.1**.....[Conv. F6i to APEX (Devsuite10g on WinXP)](#f6i_to_apex)
## 2. INST / DEINST apex_20.1_en.zip ON DB 18c
Requires  release 20.1 requires an Oracle Database release 11.2.0.4,   Oracle REST Data Services (ORDS) 19.x or later.  
 **NOT ON** : Win 10 64 bit Oracle DB 11g XE Release 11.2.0.2.0 - 64bit Production because must be Release 11.2.0.4.0 which is not XE and is not free !!
 
 apex_20.1_en.zip from http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
 
 

### tnsping xepdb1    or xe
```
PS J:\app\oraclexe\product\18.0.0\dbhomeXE\bin> tnsping xe
TNS Ping Utility for 64-bit Windows: Version 18.0.0.0.0 - Production on 06-SEP-2020 22:36:18
Copyright (c) 1997, 2018, Oracle.  All rights reserved.
Used parameter files:
J:\app\oraclexe\product\18.0.0\dbhomeXE\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sspc2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
OK (0 msec)
```

Find out in which container APEX is currently installed into:  
select r.COMP_NAME, r.VERSION, c.NAME, c.CON_ID from CDB_REGISTRY r, V$CONTAINERS c where r.CON_ID=c.CON_ID and r.COMP_ID='APEX' order by CON_ID;  
no rows selected  

select COMP_ID, VERSION, STATUS from CDB_REGISTRY where COMP_ID='APEX' order by CON_ID;  
no rows selected  


on Windows 10 pro 64 bit  Ver : 10.0.19041  DB 18c  
BY VINISH KAPOOR ON APRIL 3, 2019 on Windows and Unix/Linux systems :   
**https://www.foxinfotech.in/2020/04/installing-oracle-apex-20-1.html**  
BY VINISH KAPOOR ON APRIL 26, 2020 :   
**https://www.foxinfotech.in/2019/04/install-oracle-apex-19-1-in-eleven-easy-steps.html**   

https://matthiashoys.wordpress.com/2019/12/12/installation-of-apex-19-2-on-oracle-18c-xe-express-edition/  

1. `Run all Apex 20.1 installation scripts from J:\apex_instl\apex (F:\software\apex19\apex) `
   
2. `cd J:\apex_instl\apex`

4. sqlplus / as sysdba     or sqlplus sys/syspsw@xe as sysdba  
   @apexins.sql SYSAUX SYSAUX TEMP /i/  

5. **Apex run time environment settings** :  
   @apxrtins.sql SYSAUX SYSAUX TEMP /i/  

6. **change password** for ADMIN user eg psw=**Apex#2020**  
   @apxchpwd.sql

7. **copy Apex images** to apex/images folder
   ```
   @apex_epg_config.sql J:\apex_instl\  (F:\software\apex19\)  Do not include apex folder in this path.
   grep ORA- *.log
   grep PLS- *.log
   ```

8. **Unlock APEX_PUBLIC_USER** account and specify password.  
   ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;  
   ALTER USER APEX_PUBLIC_USER IDENTIFIED BY MYPSW;  
   
   **Neded for http://localhost:8181/apex/apex_admin :**  
   ```
   select account_status from dba_users where username = 'ANONYMOUS';
   ACCOUNT_STATUS
   --------------------------------
   EXPIRED & LOCKED
   ```
   alter user ANONYMOUS identified by anonymous;  
   alter user ANONYMOUS account unlock;  

9. Configure Apex **RESTful Services** as follows:  
   @apex_rest_config.sql  

10. Set **HTTP port** if using HTTP server as follows:  
   EXEC DBMS_XDB.SETHTTPPORT(8181);  

11. Enabling **Network Services** for Oracle Database 12c and Later  
   ```
    Begin
        DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
            host => '*',
            ace => xs$ace_type(privilege_list => xs$name_list('connect'),
                               principal_name => 'APEX_200100',
                               principal_type => xs_acl.ptype_db));
    End;
    /

   ```

**http://localhost:8181/apex/apex_admin**  

set linesize 200  
COLUMN USERNAME HEADING USERNAME FORMAT A40  
COLUMN USER_ID HEADING USER_ID FORMAT A20  
COLUMN DEFAULT_COLLATION HEADING DEFAULT_COLLATION FORMAT A20  
SELECT * FROM ALL_USERS WHERE USERNAME LIKE 'APEX%';  
```
USERNAME                                    USER_ID CREATED   COM O INH DEFAULT_COLLATION    IMP ALL
---------------------------------------- ---------- --------- --- - --- -------------------- --- ---
APEX_200100                              ########## 07-SEP-20 YES Y NO  USING_NLS_COMP       NO  NO
APEX_INSTANCE_ADMIN_USER                 ########## 07-SEP-20 YES Y NO  USING_NLS_COMP       NO  NO
APEX_PUBLIC_USER                         ########## 07-SEP-20 YES Y NO  USING_NLS_COMP       NO  NO
```

When Oracle Application Express installs, it creates three new database accounts:
1. APEX_180100 - The account that owns the Oracle Application Express schema and metadata.
2. FLOWS_FILES - The account that owns the Oracle Application Express uploaded files.
3. APEX_PUBLIC_USER - The minimally privileged account is used for Oracle Application Express configuration with Oracle REST Data Services or Oracle HTTP Server and mod_plsql.

If you configured RESTful Web services, then these additional accounts will be created:
1. APEX_REST_PUBLIC_USER - The account used when invoking RESTful Services definitions stored in Oracle Application Express.
2. APEX_LISTENER - The account used to query RESTful Services definitions stored in Oracle Application Express.




### DB 18c REST quick start
### Step 1: Install cURL that supports SSL

The examples used in this document use the cURL command-line tool to demonstrate how to access the Oracle Database REST API. To connect securely to the REST server, you must install a version of cURL that supports SSL. CURL is a command-line tool and library for** transferring data with URLs**. 

https://www.thewindowsclub.com/how-to-install-curl-on-windows-10  
curl --help shows Win 10 Curl : 2020.09.19 curl-7.72.0_4-win64-mingw.zip
```
C:\WINDOWS\system32>curl --version
curl 7.55.1 (Windows) libcurl/7.55.1 WinSSL
Release-Date: 2017-11-14, security patched: 2019-11-05
```

```
"J:\symenu\ProgramFiles\SPSSuite\SyMenuSuite\Cmder_sps\vendor\git-for-windows\mingw64\bin\curl.exe" --version --version
curl 7.71.1 (x86_64-w64-mingw32) libcurl/7.71.1 OpenSSL/1.1.1g (Schannel) zlib/1.2.11 brotli/1.0.7 libidn2/2.3.0 libssh2/1.9.0 nghttp2/1.41.0
Release-Date: 2020-07-01
```

or :  
Git for Windows will install CURL along with it. Add it to your Windows path, and you will be able to execute it from anywhere. Press start button, and type "system var".

or :  
To install cURL on your system:  

In your browser, navigate to the cURL home page at **https://curl.haxx.se/windows/**  -> curl for 64 bit  
https://curl.haxx.se/windows/dl-7.72.0_4/curl-7.72.0_4-win64-mingw.zip, built and statically linked with :
1. **OpenSSL 1.1.1g **[64bit/32bit]
2. brotli 1.0.9 [64bit/32bit]
3. libssh2 1.9.0 [64bit/32bit]
4. nghttp2 1.41.0 [64bit/32bit]
5. zlib 1.2.11 [64bit/32bit]
6. zstd 1.4.5 [64bit/32bit]

When running cURL from a Windows command shell only, you must provide an **SSL certificate authority (CA) file** or bundle **to authenticate against the Verisign CS certificate**.

Navigate to the cURL CA Extract page at http://curl.haxx.se/docs/caextract.html and download the **cacert.pem SSL CA certificate file in the folder where you installed cURL**.

Open a command window, navigate to directory where you installed cURL, and set the cURL environment variable, CURL_CA_BUNDLE, to the location of the SSL CA certificate file. For example, on a Windows system you would enter:

C:\curl> set CURL_CA_BUNDLE=cacert.pem

You are now ready to send REST requests to the Database REST API instance using cURL. See Authentication, and Use cURL.
```
J:\symenu\z_aplpsy\curl\bin
```




To be able to create workspace in PDB you need configure "Oracle REST Data services" **for each PDB you want to use**.

Based on "**Oracle REST data Services Installation and Configuration Guide** (E25066-10)" chapter 2.1 "Configuring Multiple Databases" you should:
issue commands from your apex 4.2.x directory:

java -jar ords.war setup --database <database_name>

Note: For <database_name> provide PDB service_name or SID, not CDB!

java -jar ords.war map-url --type base-patch --workspace-id <workspace_name> <path_prefix> <database_name>

Make sure you restart "Oracle REST Data Services".

Access Apex Administration Services - please use newly configured link:

http://<host_name>/ords/<workspace_name>/apex_admin

Enter credentials you used previously during "Configuring Multiple Databases" for PDB apex access. Make note that <workspace_name> is just alias, the workspace does not exists yet, but after login you are allowed to create workspace(s) in PDB finally. Additional workspaces in the same PDB can be accessed via link displayed above, so you need configure "Oracle RESTData Listener" for each PDB just once ideally.

This worked for me, hopefully it works for you too.



APEX data is stored in pluggable database, while default connection in SQL Plus is to root container cdb$root.

There is APEX_200100 listed (and you use it). Then:  
```
ALTER SESSION SET CURRENT_SCHEMA = APEX_200100 ;  
alter session set container = XEPDB1;
BEGIN  
    APEX_INSTANCE_ADMIN.UNRESTRICT_SCHEMA(P_SCHEMA => 'HR_PDB1');  
    COMMIT;  
END;  
/ 

Now check whether you can assign the HR_PDB1 schema to your workspace.

BEGIN
   APEX_INSTANCE_ADMIN.ADD_SCHEMA('hr','HR');  //hr=MY_WORKSPACE, HR=shema
END;
/
```


<br /><br /><br />
### 11111 Old APEX for deinstall

**In J:\\apex_instl** or F:\\software\\axepdb1pex19 or c\:\temp\\apex :  
         **ls shows files and 4 dirs : builder/   images/   core/   utilities/  **  
         On Unix/Linux: cd /home/usr1/apex19/apex  

**sqlplus.exe - avoid eg old sql+ from  2008. 11.1.0.7.0**  !!! :  
```
cd C:\oraclexe\app\oracle\product\18.1\server\bin\sqlplus.exe /nolog   
conn sys/MYPSW as sysdba    or  conn sys/MYPSW@XE as SYSDBA  
          SQL*Plus: Release 11.2.0.2.0 Production on Pet Kol 21 11:48:00 2020
          Copyright (c) 1982, 2014, Oracle.  All rights reserved.
--outputs no rows selected :
SELECT username  FROM dba_users where username LIKE 'FLOWS\_______' ESCAPE  '\' 
--outputs APEX_040000 : 
SELECT username  FROM dba_users where username LIKE 'APEX\_______' ESCAPE '\'
              --outputs FLOWS_FILES :
              SELECT username  FROM dba_users where username LIKE 'FLOWS%' 
--outputs no rows selected :
--If the results contain entries in the form  FLOWS_XXXXXX  or  APEX_XXXXXX  where  XXXXXX represents six numbers, those entries are candidates for removal
SELECT username  FROM dba_users
WHERE (
       username LIKE 'FLOWS\_______' ESCAPE  '\' 
       OR username LIKE 'APEX\_______' ESCAPE '\'
  )
  -- **outputs APEX_040000** :
  AND username NOT IN ( SELECT schema FROM dba_registry WHERE comp_id = 'APEX' )
/
```
-- outputs eg APEX\_200100  

 
 
### 22222 Deinstall old APEX users
```
DROP USER APEX_040000 CASCADE;
DROP USER APEX_200100 CASCADE;
```

### 33333 Instalac Apex 20.1 on Windows 10 pro 64 bit  Ver : 10.0.19041
```
Run all Apex 20.1 installation scripts from J:\apex_instl\apex (F:\software\apex19\apex)  
-- apex dir is from J:\apex_instl\1_apex_20.1_en.zip !!!

cd J:\apex_instl\apex  
C:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus.exe /nolog  
conn sys/MYPSW as sysdba    or  conn sys/MYPSW@XE as SYSDBA  

-- 6 minutes or less :  
@apexins.sql SYSAUX SYSAUX TEMP /i/

--connect to DB again because apexins.sql disconnected you from DB :  
C:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus.exe /nolog  
conn sys/MYPSW as sysdba    or  conn sys/MYPSW@XE as SYSDBA  

-- 8080 :  
SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;  

--run apxrtins.sql for Apex run time environment settings :  
@apxrtins.sql SYSAUX SYSAUX TEMP /i/  

                --Why above command Generates Error  (apex_20.1_en.zip, Win 10 64 bit)  ? :
                FAIL - Precondition for Phase 1 failed: APEX_200100 already exists
                . 2 errors occurred
                declare
                *
                ERROR at line 1:
                ORA-20001: Prerequisite checks failed; unable to proceed with APEX installation
                ORA-06512: at line 288
                Disconnected from Oracle Database 11g XE Release 11.2.0.2.0 - 64bit Production
```



### 44444 Change password for ADMIN user (cre ADMIN if not exists)
```
cd C:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus.exe /nolog  
conn sys/MYPSW as sysdba    or  conn sys/MYPSW@XE as SYSDBA
@apxchpwd.sql
           ADMIN usr created    slavkoss22@gmail.com  psw=Apex#201
```
--Created instance administrator ADMIN


### 55555 Copy Apex images to apex/images folder and postinstal steps
```
-- in J:\apex_instl\apex folder (same as previous steps !!) :  
C:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus.exe /nolog  
conn sys/MYPSW as sysdba    or  conn sys/MYPSW@XE as SYSDBA

--Note: As I copied apex_20.1_en.zip to J:\apex_instl (or F:\software\apex19 or C:\TEMP) folder, so I am specifying the same directory here for apex_epg_config.sql script. Do not include apex folder in this path !!
@apex_epg_config.sql J:\apex_instl\
-- 218 MB !  229.458.985 B :
--outputs : . Loading images directory: J:\apex_instl\/apex/images
--          timing for: Load Images Elapsed: 00:04:53.42

--Unlock APEX_PUBLIC_USER account and specify the password
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY MYPSW;
--? ALTER USER ANONYMOUS ACCOUNT UNLOCK;

--8080 :
SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
```

9. Configure Apex RESTful Services as follows:  
   -- All MYPSW :  
   @apex_rest_config.sql  

10. Set HTTP port if using HTTP server as follows:  
EXEC DBMS_XDB.SETHTTPPORT(8181);  

11. Configure network ACL for Oracle Apex 20.1 as follows:  
### Enabling Network Services for Oracle Database 12c and Later:
```
/* First connect as the SYS user with SYSDBA role */ 
sqlplus sys/syspsw@orcl as sysdba
/* Then execute the below script */
Begin
    DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
        host => '*',
        ace => xs$ace_type(privilege_list => xs$name_list('connect'),
                           principal_name => 'APEX_200100',
                           principal_type => xs_acl.ptype_db));
End;
/
```

#### Enabling Network Services for Oracle Database prior to 12c:
in J:\apex_instl\apex folder (same as previous steps !!) :
```
C:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus.exe /nolog
conn sys/MYPSW as sysdba    or  conn sys/MYPSW@XE as SYSDBA

Declare
    acl_path Varchar2(4000);
Begin
  -- Look for the ACL currently assigned to '*' and give APEX_200100
  -- the "connect" privilege if APEX_200100 does not have the privilege yet.
    Select
        acl
    Into acl_path
    From
        dba_network_acls
    Where
        host = '*'
        And lower_port Is Null
        And upper_port Is Null;
    If dbms_network_acl_admin.check_privilege(acl_path, 'APEX_200100', 'connect') Is Null Then
        dbms_network_acl_admin.add_privilege(acl_path, 'APEX_200100', true, 'connect');
    End If;
Exception
  -- When no ACL has been assigned to '*'.
    When no_data_found Then
        dbms_network_acl_admin.create_acl('power_users.xml', 'ACL that lets power users to connect to everywhere', 'APEX_200100',
        true, 'connect');
        dbms_network_acl_admin.assign_acl('power_users.xml', '*');
End;
/
```
--PL/SQL procedure successfully completed.  
Commit;  


--Now your installation and configuration are complete for Oracle Apex 20.1. You can open the Oracle Apex in a browser using the following URL:

http://localhost:8181/apex/apex_admin


ADMIN usr created    slavkoss22@gmail.com  psw=Apex#201

Before you get started, please take a moment to create a workspace. A workspace is a shared work area where multiple developers can build applications.

Once created, sign in to your workspace to begin building applications. Return to Administration Services to create additional workspaces or to manage this Application Express instance.

POSSYS  
reuse exsisting shema MERCEDES  
shema ADMIN/MYPSW

-- Workspace POSSYS provisioned with administrator ADMIN. (also INTERNAL WS)


App develop. : http://localhost:8181/apex/  or http://localhost:8181/apex/f?p=4550:1  
A d m i n :    http://localhost:8181/apex/apex_admin  or http://localhost:8181/apex/f?p=4050:3  
               or http://127.0.0.1:8080/apex/apex_admin  
WS cre. :      http://localhost:8181/apex/f?p=4050:10   
-- adds :    :13967656906380:::::  


Cloud :  
POSSYS app :          https://apex.oracle.com/pls/apex/possys/r/sales-web-app4/login  
POSSYS app develop. : https://apex.oracle.com/pls/apex/f?p=4550:1  

 
 
  

 

<br /><br /><br />
<a name="f6i_to_apex"></a>
# 3. Convert Oracle Forms 6i to APEX using frmf2xml utility
[Top](#top).....[Instalac APEX 20.1](#instapex).....**[Conv. 6i to APEX (Devsuite10g on WinXP)](#f6i_to_apex)**
  
## App f6i2apex in own WS wsconvf6 (or both POSSYS)
to convert Oracle Forms 6i (9 or ...) to APEX app modules

1. Convert fmb 6i to fmb 10
2. Convert Oracle Forms to XML.
   
   Run Forms to XML Conversion tool, **Forms2XML**, to convert Forms modules in your app. This creates XML output files.  
   **C:\\OraDS10Home1\\BIN\\frmf2xml.bat**  : frmf2xml.bat [options] file1 [file2...]  
   In WinXP (Ora Virt. Box)   D:\OraDS10Home1\BIN  
    ```
    C:\OraDS10Home1\BIN\frmf2xml.bat L:\asg\possys6\tipdok.fmb  
               Oracle Forms 10.1.2 Forms to XML Tool  
               Copyright(c) 2001, 2005, Oracle.  All rights reserved.  
               Processing module C:\OraDS10Home1\forms\test.fmb  
    XML Module saved as L:\asg\possys6\tipdok_fmb.xml  
    ```
    >or C:\OraDS10Home1\BIN\frmf2xml.bat L:\asg\hr\poplist_dept2.fmb  
    >XML Module saved as L:\asg\hr\poplist_dept2_fmb.xml

3. Create an APEX Workspace wsconvf6  
   Associate workspace with Oracle Forms application schema.

4. Create migration project mercedes or hr and load app metadata XML
   ### Upload Forms Module XML File to APEX
   1. login to wsconvf6/admin/admin
   2. Click App Builder icon.  
   3. Click Oracle Forms **Migrations** on the right side of the page 
   4. On  **App Migrations page**, **Migr. Tasks region -> App Migrations** , click **Create Project**. Enter project details:  
        1. Project unique Name, no white spaces = **mercedes or hr or...**
        2. Description = **mercedes user forms 6i converted to 10g migrated to APEX 20.1 (18.1)**  
        3. Schema = mercedes  
            Default schema is schema associated with your WS. If **multiple schemas (mercedes, hr, placa6) are associated with your WS**, all associated schemas appear in select list, arranged in alphabetical order. When this situation exists, select schema associated with the Oracle Forms you want to upload.  
       4. Forms Module XML File = **L:\asg\possys6\tipdok.fmb** which contains the information of your converted Oracle FormModule   

   5. Click Next.  Confirm page appears.

    To add more files, click Upload Another File. 

5. Analyze Oracle Forms app  
   From App Migration Workshop, verify and adjust Forms app metadata. Identify business logic required in new APEX app. Refine scope of your conversion.

   **File Name = 'tipdok_fmb.xml'**

   | | Component                    |  Count  |  Equivalent Component  | Implementation Details | Included                                 | File Name                              | Applicable |  
   | -: | :----------------------- | :-------- | :----------------------------- | :----------------------------- | :----------------------------- | :----------------------------- | :----------------------------- |
   | 1 | Alerts                             | 6             | -                                                 | alert message can be stored as **Text Message in Shared Components** of APEX app. Text Messages can be used to build translatable text strings with substitution variables that can be called from PL/SQL packages, procedures, and functions. | - | tipdok_fmb.xml | yes |

	
Alerts	6	-	An alert message can be stored as a Text Message in the Shared Components of an Oracle Application Express application. Text Messages can be used to build translatable text strings with substitution variables that can be called from PL/SQL packages, procedures, and functions.	-	tipdok_fmb.xml	Yes

6. Generate APEX App  
   Create a new app using Create Application Wizard, in App Builder part of APEX, to cover functionality being migrated.
7. Customize your APEX App  
   Open your app and customize your generated app. You can change app attributes or add new pages to app.


<br /><br />
**Not working if form contains image** :  
Processing module C:\\OraDS10Home1\\forms\\test.fmb  
ERROR - an exception has been encountered: **\_jni_gra\_export\_image failed**  

 <br /><br />
 ## Links, help...
 ```
L:\3_sw_video\4_db\2_oracle\Complete_Oracle_SQL_Course_12c\000_12cX64_APEX_app_migration_guide.pdf   
L:\2_knjige\oracle\apex\8_instal_oracle_10XE_APEX32_devsuite101_MOJ.txt  
L:\2_knjige\oracle\apex\0_apex_dokum\AEMIG\overview-migration-process.htm  

L:\1_instalac\2_instalac_ora\z_ostalo\9_ASG_F6i_f11\1_f6i  
L:\1_instalac\2_instalac_ora\z_ostalo\2_oracleXE\11XE_win  
L:\1_instalac\5_inst\1_instalac_old\0instal\1_moj_WinPostInst\z_mojeF6R6_ASGphp32bit\2_ORA_f10_DeveloperSuite10g  
C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Oracle Database 11g Express Edition
C:\oraclexe\app\oracle\product\11.2.0\server
```
https://www.foxinfotech.in/2017/03/convert-oracle-form-to-apex-using-frmf2xml-utility.html   

**APEX 20.1** :   was 18.1

APEX forum :  https://community.oracle.com/community/database/developer-tools/

http://www.oracle.com/technetwork/developer-tools/apex/application-express/podcasts-090206.html

 https://www.youtube.com/watch?v=5kPxqEXM5UM
 
https://www.youtube.com/watch?v=gg6Gy1VtqmA


You **must install Oracle Developer Suite (best on WinXP !!) to convert** Oracle Forms applications and Oracle Reports to XML format. 

Convert:
1. Oracle Forms FormModule (. FMB ), ObjectLibrary (. OLB ), or MenuModule (. MMB ) files to XML format using the Forms to XML conversion tool,  Forms2XML
2. Oracle Reports (including, binary (. RDF ),  ASCII  (. REX ), and . JSP ) to XML format using the File Conversion option in Reports Builder
3. PL/SQL library . PLL  files to . PLD  text files using the File Conversion option in Oracle Forms Builder

 
 
 
 

**C:\\OraDS10Home1\\BIN\\frmf2xml.bat**
```
@ECHO OFF
REM
REM  DESCRIPTION
REM    This file is used to call the Forms2XML conversion tool.
REM    It takes .fmb, .mmb, and .olb files and converts them into XML.
REM 
REM  NOTES
REM    It wraps the class oracle.forms.util.xmltools.Forms2XML and passes
REM    any parameters given onto the tool.
REM    You can only use the standard nine parameters, but these can include
REM    wildcards in the filenames.
REM

REM Setup path to include necessary Forms dlls.
set PATH=C:\OraDS10Home1\bin;%PATH%

REM Run the tool with the required jar files added to the classpath
C:\OraDS10Home1\jdk\bin\java -classpath C:\OraDS10Home1\forms\java\frmxmltools.jar;C:\OraDS10Home1\forms\java\frmjdapi.jar;C:\OraDS10Home1\lib\xmlparserv2.jar;C:\OraDS10Home1\lib\xschema.jar oracle.forms.util.xmltools.Forms2XML %*
```



<br /><br /><br />
***  
Videos : https://apex.oracle.com/en/learn/videos/
***  
[Top](#top).....[Instalac APEX 20.1](#instapex).....[Conv. 6i to APEX (Devsuite10g on WinXP)](#f6i_to_apex)