The Problem
Right now In the company we are upgrading our system form Oracle Forms/Reports 6i to Oracle Forms/Reports 11g.I found myself in need of compiling multiple Forms and Reports - about 1200 each -.
To Open each and compile is rather dull and exhausting process
The Solution
A- Forms and PLL and menus:
I found a Script about compiling multiple Forms. Here it is how to do it.1- Create a new file with Notepad or Notpad++ - I prefer Notepad++ - and name it "compile.bat"
2- Paste The following code into the "compile.bat" file. Note: This code also compile ".pll" and ".mmb" files.
@ECHO OFF
cls
Echo libraries compilation....
for %%f IN (*.pll) do ( frmcmp userid=scott/tiger@orcl module=%%f batch=yes module_type=library compile_all=yes window_state=minimize & ECHO %%f )
ECHO libraries compilation finished ---
Echo menus compilation....
for %%f IN (*.mmb) do ( frmcmp userid=scott/tiger@orcl module=%%f batch=yes module_type=menu compile_all=yes window_state=minimize & ECHO %%f )
ECHO menus compilation finished ---
Echo forms compilation....
for %%f IN (*.fmb) do ( frmcmp userid=scott/tiger@orcl module=%%f batch=yes module_type=form compile_all=yes window_state=minimize & ECHO %%f )
ECHO forms compilation finished ---
3- Replace "scott/tiger@orcl" with the connection your connection string "userid/password@databasename"
4- Place the "compile.bat" file into the folder that has the your forms
5- Double click the "compile.bat" file to run it.
6- The error logs will be written to file with ".err" extension.
7- Note: In case you don't want to compile a ".pll" file just remove its for loop form the bat file, same with other types.
B- Reports:
I worked it out the same way as I did with the forms. Here it is how to do it1- Create a new file and name it "rpcnvrt.bat"
2- Paste The following code into the "rpcnvrt.bat" file.
@ECHO OFF
cls
Echo report convertion....
for %%f IN (*.rdf) do ( rwconverter userid=scott/tiger@orcl stype=RDFFILE DTYPE=REPFILE batch=yes OVERWRITE=YES source=%%f & ECHO %%f )
ECHO report compilation finished ---
3- Replace "scott/tiger@orcl" with the connection your connection string "userid/password@databasename"
4- Place the "rpcnvrt.bat" file into the folder that has the your reports
5- Double click the "rpcnvrt.bat" file to run it.
6- The error logs will be written to file with "reports.log" extension.
7- Note: For more options on the rwconverter visit this link.
- BATCH
- CMDFILE
- COMPILE_ALL
- CUSTOMIZE
- DEST
- DTYPE
- DUNIT
- FORMSIZE
- JVMOPTIONS
- OVERWRITE
- P_AVAILABILITY
- P_DESCRIPTION
- P_FORMATS
- P_NAME
- P_OWNER
- P_PFORMTEMPLATE
- P_PRINTERS
- P_PRIVILEGE
- P_SERVERS
- P_TRIGGER
- P_TYPES
- PAGESIZE
- PARAMETER
- RECURSIVE_LOAD
- SOURCE
- STYPE
- USERID
8- Note: Spaces in the name of the reports seems to be causing an error. Place double quotes around %%f to be like this "source=%%f".
9- I placed the the attributes for the report conversion in this order because some error happens that I didn't have the time to check it out.
Any questions I will be happy to do my best to answer
