Hi,
we use a similar method for compilation.
we have a table named GEN_Object containing form/report/library names.
SQL> desc gen_object;
Name Null? Type
--------------------------
PROJECTCODE NOT NULL VARCHAR2(30)
OBJECTTYPE NOT NULL VARCHAR2(1) --F/Form, L/Library, R/Report
OBJECTNAME NOT NULL VARCHAR2(40) -- Name of form without extension
COMPILENEED NOT NULL NUMBER(1)
PROGRAMMER NOT NULL VARCHAR2(6) -- prefix of e-mail ex. musdu for musdu@kocbank.com.tr
SEQUENCE NOT NULL NUMBER(6)
BUILDDATABASE NOT NULL VARCHAR2(50) -- connect database for test environment
SIGNOFFDATABASE NOT NULL VARCHAR2(50) -- connect database for production
Programmers put a tag on formname using CVS (PVCS may have a facility like this) Tags can be BUILD or SIGNOFF. We have a scheduled job on a dedicated pc. It starts automatically and downloads all items tagged BUILD and generates it using builddatabase. Then deletes BUILD tag and create two new tags; TEST and TEST_DDMMYYYYHHMM. So we can use this labels in order to see which version in TEST. Above explanations are valid for SIGNOFF tag. (new tags are LIVE and LIVE_DDMMYYYYHHMM)
if an error occurs during above process, an e-mail is sent to programmer. We coded a forms application for this purpose.
regards.
Main Topics
Browse All Topics
by: HenkaPosted on 2004-05-24 at 21:38:00ID: 11148766
I hope this note 191529.1 from Metalink will help you.
This script code compiles all the Forms and Reports modules residing in a directory.
Oracle Forms Developer, 6i, 9.0.X
Oracle Reports Developer, 6i, 9.0.X
Platform Independent
Execution Environment:
Windows command prompt, UNIX shell
Access Privileges:
Requires write privileges in the destination directory and read privileges in the source directory.
Instructions:
When copying the script be aware to remove line feeds in the list of parameters for the executables.
Please note that if you are FTPing this script from a Windows machine please do it in ASCII mode.
PROOFREAD THIS SCRIPT BEFORE USING IT! Due to differences in the way text editors, e-mail packages, and operating systems handle text formatting (spaces, tabs, and carriage returns), this script may not be in an executable state when you first receive it. Check over the script to ensure that errors of this type are corrected.
The script for Reports 9i will return error 'REP-0202: Attempt to free a null pointer' until Bug 2523785 is resolved. The error can be ignored.
For Windows
Forms/Reports 6i
REM WINDOWS COMPILE FORMS
::compile_forms.bat
cls
Echo compiling Forms....
for %%f IN (*.fmb) do ifcmp60 userid=scott/tiger@v817 module=%%f batch=yes
module_type=form compile_all=yes window_state=minimize
ECHO FINISHED COMPILING
REM WINDOWS COMPILE REPORT
::compile_report.bat
cls
Echo compiling Report .....
for %%f IN (*.rdf) do RWCON60 userid=scott/tiger@v817 batch=yes source=%%f
stype=rdffile DTYPE=REPFILE OVERWRITE=yes logfile=log.txt
ECHO FINISHED COMPILING
Forms/Reports 9.0.X
REM WINDOWS COMPILE FORMS
::compile_forms.bat
cls
Echo compiling Forms....
for %%f IN (*.fmb) do ifcmp90 userid=scott/tiger@v817 module=%%f batch=yes
module_type=form compile_all=yes window_state=minimize
ECHO FINISHED COMPILING
REM WINDOWS COMPILE REPORT
::compile_report.bat
cls
Echo compiling Report .....
for %%f IN (*.rdf) do rwconverter userid=scott/tiger@v817 batch=yes
source=%%f stype=rdffile DTYPE=REPFILE OVERWRITE=yes logfile=log.txt
ECHO FINISHED COMPILING
For UNIX
Forms/Reports 6i
#UNIX Forms Compile
#compile_forms.sh
for i in `ls *.fmb`
do
echo Compiling Form $i ....
f60genm userid=scott/tiger@bs817 batch=yes module=$i module_type=form
compile_all=yes window_state=minimize
done
#UNIX COMPILE REPORTS
#compile_rep.sh
for i in `ls *.rdf`
do
echo Compiling Report $i ...
rwcon60 userid=scott/tiger@bs817 batch=yes source=$i stype=rdffile
dtype=repfile overwrite=yes
done
Forms/Reports 9.0.X
#UNIX Forms Compile
#compile_forms.sh
for i in `ls *.fmb`
do
echo Compiling Form $i ....
f90genm userid=scott/tiger@bs817 batch=yes module=$i module_type=form
compile_all=yes window_state=minimize
done
#UNIX COMPILE REPORTS
#compile_rep.sh
for i in `ls *.rdf`
do
echo Compiling Report $i ...
rwconverter.sh userid=scott/tiger@bs817 batch=yes source=$i
stype=rdffile dtype=repfile overwrite=yes
done
Disclaimer
EXCEPT WHERE EXPRESSLY PROVIDED OTHERWISE, THE INFORMATION, SOFTWARE,PROVIDED ON AN "AS IS" AND "AS AVAILABLE" BASIS. ORACLE EXPRESSLY DISCLAIMS ALL WARRANTIES OF ANY KIND, WHETHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR
PURPOSE AND NON-INFRINGEMENT. ORACLE MAKES NO WARRANTY THAT: (A) THE RESULTS THAT MAY BE OBTAINED FROM THE USE OF THE SOFTWARE WILL BE ACCURATE OR RELIABLE; OR (B) THE INFORMATION, OR OTHER MATERIAL OBTAINED WILL MEET YOUR EXPECTATIONS. ANY CONTENT, MATERIALS, INFORMATION OR SOFTWARE DOWNLOADED OR OTHERWISE OBTAINED IS DONE AT YOUR OWN DISCRETION AND RISK. ORACLE SHALL HAVE NO RESPONSIBILITY FOR ANY DAMAGE TO YOUR COMPUTER SYSTEM OR LOSS OF DATA THAT RESULTS FROM THE DOWNLOAD OF ANY CONTENT, MATERIALS, INFORMATION OR SOFTWARE.
ORACLE RESERVES THE RIGHT TO MAKE CHANGES OR UPDATES TO THE SOFTWARE AT ANY TIME WITHOUT NOTICE.
Limitation of Liability
IN NO EVENT SHALL ORACLE BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL OR CONSEQUENTIAL DAMAGES, OR DAMAGES FOR LOSS OF PROFITS, REVENUE, DATA OR USE, INCURRED BY YOU OR ANY THIRD PARTY, WHETHER IN AN ACTION IN CONTRACT OR TORT, ARISING FROM YOUR ACCESS TO, OR USE OF, THE SOFTWARE.
SOME JURISDICTIONS DO NOT ALLOW THE LIMITATION OR EXCLUSION OF LIABILITY. ACCORDINGLY, SOME OF THE ABOVE LIMITATIONS MAY NOT APPLY TO YOU.