The FRMCMP command is used to compile Oracle Forms modules (.fmb files) and library modules (.pll files). Here's how you can use FRMCMP for compiling both .fmb and .pll files:
Compiling .FMB (Forms Module):
To compile a Forms module (.fmb), use the following syntax:
FRMCMP module=fmb_file_name userid=your_db_username/your_db_password[@your_database] module_type=form batch=yes compile_all=yes
Compiling .PLL (Library Module):
To compile a Library module (.pll), use a similar syntax:
FRMCMP module=pll_file_name userid=your_db_username/your_db_password[@your_database] module_type=library batch=yes compile_all=yes
Example:
FRMCMP module=myform.fmb userid=scott/tiger@orcl module_type=form batch=yes compile_all=yes
FRMCMP module=mylibrary.pll userid=scott/tiger@orcl module_type=library batch=yes compile_all=yes
Optional Parameters
frmcmp Module=<pll name> Userid=<userid/password> [Parameters].
Optional parameters with default values given:
Module_Type=FORM Module type (FORM, MENU, LIBRARY). Statistics=NO Show statistics. Logon=YES Logon to database. Batch=NO Don't display messages on the screen. Output_File=<file> Write output to file. Script=NO Write script file. Parse=NO Parse script file. Upgrade=NO Upgrade module to current version. Upgrade_Roles=NO Upgrade SQL*Menu 5.0 role information. Version=45 Version to upgrade (23, 30, 40, 45, or menu 50). Crt_File=<crt file> CRT file for version 2.x form upgrade. Build=Yes Build a runform/runmenu file when upgrading. Add_Triggers=NO Add KEY-UP/DOWN triggers during upgrade. Nofail=NO Add NOFAIL keyword to trigger steps. Debug=NO Build/Run with debug information. Compile_All=NO Compile all PL/SQL code. Strip_Source=NO Strip pl/sql source code from library. Window_State=Normal Root window state: (Normal, Maximize, Minimize.) Help=NO Show this help information. Options_Screen=NO Display Options window (on bitmap only). Widen_Fields=NO Add one character to display width. Print_Version=NO Print version used to save module. Forms_Doc=NO Print Forms Doc report. |
Example:
If we want to compile PLL the the syntax is:
frmcmp module=<path of pll file> userid=apps/<pwd> output_file=<path for generating plx> module_type=LIBRARY batch=yes compile_all=special
or
frmcmp_batch module=CUSTOM.pll userid=apps/appspass output_file=CUSTOM.plx module_type=LIBRARY compile_all=special
**************************************************************************************************
If we want compile forms FMB then:
In R12
frmcmp module=$AU_TOP/forms/US/CUSTOM_OE.fmb userid=apps/appspassword output_file=$PRODUCT_TOP/forms/USCUSTOM_OE.fmx module_type=form compile_all=yes
or
frmcmp_batch module=$AU_TOP/forms/US/CUSTOM_OE.fmb userid=apps/appspassword output_file=$PRODUCT_TOP/forms/USCUSTOM_OE.fmx module_type=form compile_all=yes
In 11i
f60gen module=$AU_TOP/forms/US/CUSTOM_OE.fmb userid=apps/appspassword output_file=$PRODUCT_TOP/forms/USCUSTOM_OE.fmx module_type=form compile_all=yes
Adjust the parameters based on your specific requirements and environment. Ensure that you have the necessary permissions and connectivity to the Oracle database before attempting to compile.
9 Comments
Thanks Himanshu...
ReplyDeleteHi Himanshu
ReplyDeletewhen I compiling my fmb its showing successful compilation to all trigger and block but showing form not created message.Can you provide any help on this
Hi, How can this compilation be implemented via Jenkins?
ReplyDeleteHi, How can this compilation be implemented via Jenkins?
ReplyDelete
ReplyDeleteGood information It mayt be Helpful for me thanks a lot for sharing, Know how Development and operations will work in one platform
Devops training
for more inforamtion
Amazon web Services Training
Professional Salesforce CRM Training
This comment has been removed by the author.
ReplyDeleteadvanced thanks, I facing a problem while compiling pl/qsl Library in oracle 12c forms server.
ReplyDeleteerror as bellow:
PDE-PLI018 Could not find library ofg4bsl
note: here ofg4bsl is my custom library.
Is the Custom Library set in the path before the compilation
Deleteyes, first of all, I have export all environment variable and path.
ReplyDeleteplease find following script:
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.1
export MW_HOME=$ORACLE_HOME
export WLS_HOME=$MW_HOME/wlserver
export WL_HOME=$WLS_HOME
export DOMAIN_BASE=$ORACLE_BASE/config/domains
export DOMAIN_HOME=$DOMAIN_BASE/mydomain
export JAVA_HOME=/u01/app/oracle/jdk1.8.0_291
export PATH=$JAVA_HOME/bin:$PATH
export PATH=/u02/RILS/Ins:$PATH
cd /u01/app/oracle/config/domains/mydomain/config/fmwconfig/components/FORMS/instances/forms1/bin
my library is exist on :/u02/RILS/Ins/
Post a Comment