This discussion is archived
11 Replies Latest reply: Mar 25, 2013 6:41 AM by Paul M. RSS

How to compile a Form in Unix

LuKKa Newbie
Currently Being Moderated
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 .
Please help me .
  • 1. Re: How to compile a Form in Unix
    HamidHelal Guru
    Currently Being Moderated
    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 .
    Please help me .
    check this {thread:id=2346202}

    Hope works ;)

    Mark correct/helpful to help others to get right answer(s).*
  • 2. Re: How to compile a Form in Unix
    LuKKa Newbie
    Currently Being Moderated
    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:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\DevSuite10gR2\bin\frmcmp.exe)(HOST=ITINBAC-DW0213)(USER=snmha2))))

    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
    TNS-12560: TNS:protocol adapter error
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 126
    nt OS err code: 0
  • 3. Re: How to compile a Form in Unix
    Amatu Allah Guru
    Currently Being Moderated
    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
    LuKKa Newbie
    Currently Being Moderated
    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
    HamidHelal Guru
    Currently Being Moderated
    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
    Paul M. Oracle ACE
    Currently Being Moderated
    for %%f IN (*.fmb) do <full_path>frmcmp ........
    On Unix ?
  • 7. Re: How to compile a Form in Unix
    Paul M. Oracle ACE
    Currently Being Moderated
    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
    HamidHelal Guru
    Currently Being Moderated
    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
    LuKKa Newbie
    Currently Being Moderated
    Hi
    Thank you very much .
    It is working fine for me .
  • 10. Re: How to compile a Form in Unix
    LuKKa Newbie
    Currently Being Moderated
    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
    Paul M. Oracle ACE
    Currently Being Moderated
    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
            $ORACLE_HOME/bin/frmcmp.sh $FRM username/password@DB module_type=form 1>$FRM.log 2>&1
    done
    If you execute the script with a form name as argument, only that form will be compiled, otherwise all forms within the directory will be compiled.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points