Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Batch convert Oracle library pll files to text plx (Read 10461 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Batch convert Oracle library pll files to text plx
10.04.07 at 10:37:41
 
Batch convert Oracle library pll files to text plx
 
To batch convert Oracle library .pll files to text format: .pld files, you can use the following code.

for %%f in (*.pll) do start /min /wait C:\OraHome1\bin\ifcmp90 module=%%f userid=scott/tiger@mydb module_type=library batch=yes script=yes output_file=%%f.pld

 
Save the above code as one line in a new text file. Rename the file to .bat.
 
Batch convert Reports rdf files to text rex format
 
To batch convert Oracle .rdf reports files to text format .rex you can use the following command:

for %%r in (*.rdf) do start /min /wait C:\OraHome1\bin\rwconverter userid=scott/tiger@mydb stype=rdffile source=%%r dtype=rexfile dest=%%r.rex batch=yes
 

 
Save the above code as one line in a text file and name it .bat.
 
Batch convert Forms fmb to fmt files
 
To batch convert Oracle forms .fmb files to .fmt text format you can use the following batch file:
 

for %%f in (*.fmb) do start /min /wait C:\OraHome1\bin\ifcmp90 module=%%f userid=scott/tiger@mydb module_type=form batch=yes script=yes

 
Save this code as one line in a text file. Rename the file to .bat and store it in the directory with your fmb files.
 
Unfortunately these text versions do not contain text pl/sql. It seems the pl/sql is saved in the files as binary.
Back to top
 
« Last Edit: 11.04.07 at 07:26:51 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1