11 Replies Latest reply on Mar 25, 2013 1:41 PM by Paul M.

# How to compile a Form in Unix

Dear all
I am using forms 10G.
I have a form and I want to compile it in Unix .
Can you please tell me the solution step by step .
I was reading the old blogs here ,and tried the same but did not get the solution .
• ###### 1. Re: How to compile a Form in Unix
LuKKa wrote:
Dear all
I am using forms 10G.
I have a form and I want to compile it in Unix .
Can you please tell me the solution step by step .
I was reading the old blogs here ,and tried the same but did not get the solution .

Hope works ;)

• ###### 2. Re: How to compile a Form in Unix
Hi
I tried this as you mentioned in the link .

frmcmp userid=userid/pass@aaa module=%%f batch=yes module_type=form compile_all=yes

I got this error in the same location where my fmbs are there :-

Fatal NI connect error 12560, connecting to:

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.1.0.4.0 - Production
Time: 21-MAR-2013 07:45:42
Tracing not turned on.
Tns error struct:
ns main err code: 12560
ns secondary err code: 0
nt main err code: 530
nt secondary err code: 126
nt OS err code: 0
• ###### 3. Re: How to compile a Form in Unix
Hi Lukka

i think u r in a hurry pls check Hamid's correct answer in the second page of the thread 's link given by him :)

Amatu Allah
• ###### 4. Re: How to compile a Form in Unix
Hi
Sorry to say but I cant find any pages apart from 1st page . Only one page i can see there . At the end of the page the page number should come if there is more than 1 page but here it is showing only 1 page .
• ###### 5. Re: How to compile a Form in Unix
LuKKa wrote:
Hi
Sorry to say but I cant find any pages apart from 1st page . Only one page i can see there . At the end of the page the page number should come if there is more than 1 page but here it is showing only 1 page .
Hello , Lukka
try
Echo compiling forms 10g ....
for %%f IN (*.fmb) do <full_path>frmcmp userid=User_name/pass@orcl module=%%f batch=yes module_type=form compile_all=yes window_state=minimize
ECHO form compilation complete
• ###### 6. Re: How to compile a Form in Unix
for %%f IN (*.fmb) do <full_path>frmcmp ........
On Unix ?
• ###### 7. Re: How to compile a Form in Unix
I am using forms 10G.
I have a form and I want to compile it in Unix .
You may try using frmcmp.sh in \$ORACLE_HOME/bin. Do it in a graphical window.
• ###### 8. Re: How to compile a Form in Unix
Paul M. wrote:
for %%f IN (*.fmb) do <full_path>frmcmp ........
On Unix ?
sorry, not checked
try
frmcmp userid=\$USERDB/\$PWDB@\${ORACLE_SID} module=xx module_type=FORM compile_all=yes
• ###### 9. Re: How to compile a Form in Unix
Hi
Thank you very much .
It is working fine for me .
• ###### 10. Re: How to compile a Form in Unix
Echo compiling Forms....
for %%f IN (*.fmb) do frmcmp.sh userid=userid/password@DB1 module=%%f batch=yes module_type=form compile_all=yes window_state=minimize
ECHO FINISHED COMPILING

Is this comand will work ?
How can I give the fmb name instread of "compile_all=yes " ?
• ###### 11. Re: How to compile a Form in Unix
for %%f IN (*.fmb) do frmcmp.sh userid=userid/password@DB1 module=%%f batch=yes module_type=form compile_all=yes window_state=minimize

Is this comand will work ?
On Windows yes, on Unix no, that's the Windows syntax.
How can I give the fmb name instread of "compile_all=yes " ?
"compile_all=yes" doesn't mean compile all forms, but compile all Pl/Sql code within the form. On Linux I use something like the following :
. \$HOME/.bash_profile
export Filename=\$1
if [ "\$Filename" ]
then
Filename=`echo \$Filename | cut -f1 -d"."`
else
Filename=*
fi

for FRM in \$Filename.fmb
do
echo \$FRM