Connecting Tech Pros Worldwide Help | Site Map

need to compile a file

Newbie
 
Join Date: Nov 2007
Posts: 2
#1: Nov 29 '07
I am very new to SQL..can anyone tell me the procedure to compile a .FMB file (oracle forms builder) in SQL.

Thanks in advance..
amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#2: Nov 29 '07

re: need to compile a file


Quote:

Originally Posted by VaibhavD

I am very new to SQL..can anyone tell me the procedure to compile a .FMB file (oracle forms builder) in SQL.

Thanks in advance..

Hi VaibhavD,

Welcome to TSDN!!

Please make sure you follow POSTING GUIDELINES every time you post in this forum

Thanks
MODERATOR
amitpatel66's Avatar
Moderator
 
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#3: Nov 29 '07

re: need to compile a file


Quote:

Originally Posted by VaibhavD

I am very new to SQL..can anyone tell me the procedure to compile a .FMB file (oracle forms builder) in SQL.

Thanks in advance..

You can use any one of the below command to compile a fmb:

Connect to unix box of particular instance and use below command:

Expand|Select|Wrap|Line Numbers
  1. f60gen Module=$AP_TOP/forms/US/<fmb_name>.fmb userid=uid/pwd Module_type=FORM Output_File=$AP_TOP/forms/US/,fmx_name>.fmx
  2.  
  3. f60gen userid=uid/pwd Module=<fmb_name>.fmb 
  4. output_file=<fmx_name>.fmx  module_type=form batch=no compile_all=special
  5.  
Newbie
 
Join Date: Nov 2007
Posts: 2
#4: Nov 30 '07

re: need to compile a file


Thanks for the reply..

I wanted to compile the file from windows and somehow i managed to do using ctrl+k..after compilation it has created .FMX file..if we double this file it shud ask for username,password and database name but it asks 'windows can not open this file'..any software needs to be installed to open .fmx file..
Reply