Welcome to Oracle

May 23, 2012

Enable Forms 6i short keys in Forms 10g and Forms 11g

Shortcuts in Forms 10g and 11g are different from Forms 6i keys. For example, Forms 6i uses F10 as short key to save records while in Forms 10g and 11g, CTRL+S  is default short key to save or commit changes.  If you have migrated an app from older version then probably you would be looking some way to retain key shortcuts. (more…)

February 11, 2011

Create Oracle lite Database (odb) using olite Mobile Development Kit

Filed under: Oracle Database — admin @ 4:53 pm

Oracle Database Lite (olite) is small-scale database for small devices. Oracle Lite can be used in following two design patterns,

  1. You can configure olite database to Mobile client and use automatic synchronization feature of olite server to replicate data between mobile device and oracle database server.
  2. You can use an independent olite database with you mobile application.

Whatever way is used, the data in the mobile is stored in small mobile database files with ODB and OBS extension. ODB file contains data while indexes are stored in OBS file. In olite version, all objects are stored in ODB file. (more…)

January 6, 2011

FireFox, IE crash with Forms 10g, Replace Jinitiator with JRE

Filed under: Oracle Forms & Reports 10g — admin @ 10:55 pm

Oracle Jinitiator is no longer compatible with oracle forms services. By default, Oracle Forms services 10g uses Jinitiator to run Forms applications. Jinitiator was compatible with Internet Explorer 6 and Firefox version 2.0. (more…)

October 11, 2010

Sequence number for Primary key in oracle ADF, JDeveloper

Filed under: ADF & JDeveloper,Fusion MiddleWare 11g — admin @ 4:24 pm

If you have created an Entity object with a primary key field.  The question is, how you will generate maximum serial no for primary key filed and where the logic will be placed?  There are two methods to do this, using row level database trigger or using application level logic to obtain sequence  no for primary key. (more…)

September 7, 2010

Using transient Attribute with “Derived from SQL Expression” in JDeveloper 11g

Filed under: ADF & JDeveloper,Fusion MiddleWare 11g — admin @ 11:45 am

Transient attribute can be used to calculate a value based on SQL expression. This may be very helpful, for example, you can use a transient attribute in “SCOTT.EMP” Entity object definition to get name of the department for all employees. (more…)

August 24, 2010

Oracle Application Development Framework (ADF) and Oracle Forms Developers

Filed under: ADF & JDeveloper,Forms 11g,Fusion MiddleWare 11g — admin @ 11:35 am

I want to share my first impression of ADF and I am sure everyone with Oracle Forms background will feel same. I have been working in oracle Forms and Reports for more than five years.  I have development experience in Oracle Developer 6i/9i/10g and Forms, Reports 11g. After reading Oracle’s Statement of Direction for Forms and reports, I decided to learn ADF for web-based application development. (more…)

July 2, 2010

Minimizing Forms 11g Application’s First Time Startup overhead

Filed under: Forms 11g,Fusion MiddleWare 11g — admin @ 2:43 pm

When  client accesses Forms application for the first time, java run-time classes bundled in JAR files are downloaded to client JRE cache.  These files include frmall.jar, frmwebutil.jar and jacob.jar. Cumulative size of these files is more than 2mb. (more…)

June 10, 2010

Key Mapping in Oracle Forms 10g and Forms 11g | Shortcut keys

Key mapping or key binding defines how an application should respond when mapped key is typed. Usually application executes some function in repose. For example in Forms 6i, when user types F9, List of value is displayed to the user. It means that key F9 is mapped to function “List of Values”. (more…)

June 9, 2010

Hide username and password while calling oracle Reports

If you have not configured reports with Oracle Single Sign-on, Oracle report server explicitly requires username and password when report is called using Web.Show_document(). Username and password is required in report calling URL, for example following method calls a reports using Web.Show_Documnet(). (more…)

May 12, 2010

Missing Plugins Error in Firefox with Oracle Forms Services 11g

Filed under: Forms 11g,Fusion MiddleWare 11g — admin @ 12:45 pm

At the time of installation Forms services 11g is configured to work with a specific version of  java run-time environment. You can find it in your FORMSWEB.CFG file. (more…)

Older Posts »

Powered by WordPress