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 compile Oracle forms (Read 7033 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Batch compile Oracle forms
10.06.11 at 15:20:14
 
Batch compile Oracle forms
 
To batch compile Oracle forms and menus the following batch file can be used. Save as compile.bat:
 



echo off
echo Compile >compile.log
time /t             >>compile.log
for /f "delims=." %%G in ('dir /b *.fmb') do (call :compile_form %%G)
for /f "delims=." %%G in ('dir /b *.mmb') do (call :compile_menu %%G)
goto :the_end
 
:compile_form
set _string=%1
echo Compile form %_string%                                     >>compile.log
frmcmp Module=%_string%.fmb Userid=user/pass@db Module_type=Form batch=yes >>compile.log
if not exist %_string%.fmx echo ........ No executable >>compile.log
if not exist %_string%.fmx echo No executable
goto :eof
 
:compile_menu
set _string=%1
echo Compile form %_string% >>compile.log                   >>compile.log
frmcmp Module=%_string%.mmb Userid=user/pass@db Module_type=Menu >>compile.log
if not exist %_string%.mmx echo ......... No executable >>compile.log
if not exist %_string%.mmx echo No executable
goto :eof
 
:the_end
time /t >>compile.log
echo the_end
pause



 
Note batch=yes causes the compiler to not stop on warnings. See .err files for messages.
Back to top
 
« Last Edit: 10.06.11 at 15:22:34 by Gerrit-Jan Linker »  

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