11 Replies Latest reply: Mar 25, 2013 8:41 AM by Paul M. RSS

    How to compile a Form in Unix

    LuKKa
      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
          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
            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 Neveen Ebrahim
              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
                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
                  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.
                    for %%f IN (*.fmb) do <full_path>frmcmp ........
                    On Unix ?
                    • 7. Re: How to compile a Form in Unix
                      Paul M.
                      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
                        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
                          Hi
                          Thank you very much .
                          It is working fine for me .
                          • 10. Re: How to compile a Form in Unix
                            LuKKa
                            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.
                              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.