Sunday, June 5, 2011

How to Compile All Oracle Forms(.fmb to .fmx) Together ?

You need to write a script on the operating system to call "frmcmp" executable.


1.Pls open a note pad and paste the following lines...


::compile_forms.bat
cls
Echo compiling Forms....
for %%f IN (*.fmb) do frmcmp.exe userid=user_name/password@db  module=%%f batch=yes
    module_type=form compile_all=yes window_state=minimize
ECHO FINISHED COMPILING



2. change the user name , password and the database alias accordingly...
3. Pls save the file with a name.bat then...
4.put this file in the forms folder then...
5.Double click on that batch it will compile all the forms in that folder consequently...

22 comments:

  1. This is very interesting topic which describe how you can compile all Oracle forms together. The method is not difficult but you need to be bit careful while applying it as there is no chance of error. Consider the above points. Thanks.

    ReplyDelete
  2. Hi.
    Batch file is executing but not creating fmx.. is there any way we can generate a log of the same.

    Thanks & Regards
    Hussain Zaki

    ReplyDelete
  3. Salam Hussain Zaki,

    Did you put the batch file in the same folder, where the .fmb exist ?
    And what is your form version ?
    --if 6i then frmcmp.exe should be ifcmp60.exe

    Thanks

    ReplyDelete
  4. Thank you!! perfect compilation, regards

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Thanks, very useful!!!

    ReplyDelete
  7. Thanks Allah (swt) for this... your are welcome @ anonymous

    ReplyDelete
  8. It's very helpful bro ..!!

    ReplyDelete
  9. Replies
    1. Please make sure that files are not in read-only mode. For me .err file and .fmx is generating and if i open ".err" it contatins the message "Created form file xxx.fmx"

      Delete
  10. Thank you. It is very helpfull...

    ReplyDelete
  11. Thanks bro...it helps me.

    ReplyDelete
  12. Hi,
    I have 19 forms which are giving error FRM-30085: Unable to adjust form for output.
    All of them compile and build fine when compiling in forms builder.
    i tried with frmcmp.sh module=example.fmb userid=$UP module_type=FORM
    19 forms errored - same error no other message
    Then I changed the command to frmcmp.sh module=example.fmb userid=$UP module_type=FORM compile_all=YES
    Now 9 forms erred same error message... what other setting do u think i should add and check?

    ReplyDelete
    Replies
    1. were you able to resolve this issue? I have a form with the same error that has successfully compiled previously and still compiles in builder without error - please email me at aleech@fs.fed.us if you found a solution

      Delete
  13. hi,
    i am new in development.i saw your answer. but i am not understand where i have to put that file means in which form

    ReplyDelete
    Replies
    1. put the batch file along with your forms.

      Delete
  14. hi,
    i have migrated forms from 6i to 11g .few fmbs when opened from forms builder 11g compiles(shift+ctrl+k) and generates fmx (ctrl+T) but if i run the same fmb using compile.bat file it will give forms error FRM-30085: Unable to adjust form for output.
    I tried converting into xml and xml back to fmb still it dint work .
    Kindly help .

    ReplyDelete
    Replies
    1. Please post at https://community.oracle.com/community/development_tools/forms

      Delete