Feb 28 2009

Read-only fields on APEX tabular form except on a new row

Category: APEXittichai @ 8:11 pm

I was asked by our APEX developer whether or not some fields of the tabular form created by wizard, except on a new row when “Add Row” is clicked, can be made read-only. This is a part of business requirements that the existing parameters should not be modified by end users.

I started searching for the existing solutions and found that most call for using the manually-created tabular form. However, one comment from this forum post suggested Javascript to perform task. Even though there was no code given, I’d like explore this option.

With information from Denes Kubieck’s Demo application and Patrick Wolf’s post on “Which Tabular Form Column is mapped to which Apex_Application.g_fxx array?”, this is the sample of my simple solution which uses Javascript to make fields read-only.

Please note that in this sample application, there are other things I included to show our developers. I added a page-level validation to ensure that there is no duplication in a selected field entry. Even though there is an unique constraint on this column, by using validation, it is more informative to users. The pop-up help reminds users that the field is protected and no duplication is allowed.

Tags: , ,


Feb 13 2009

Oracle lifetime support policy

Category: Databaseittichai @ 4:58 pm

Our organization just started looking into upgrading all older versions of database including 9i. Definitely one of many business justifications for upgrade is to avoid de-supporting from vendor.  I recently looked into Oracle’s support policy and did not realize that it offers the lifetime support policy on its entire technology stack, from database to middleware to applications.

Three levels of supports are

  • Premier Support covers the first five years after general availability date
  • Extended Support provides an extra three years of support for specific releases for an additional fee.
  • Sustaining Support provides lifetime support with only limited features.

The sustaining support lacks our major needed components such as critical patch, new updates/fixes, etc, but it seems to be a good option for those who really could not upgrade with whatever their business reason is.

These are the support dates for Oracle database releases -
Oracle support dates

Well, it is time to start planning. The July 2010 date for 9i R2 is approaching. :-)

Tags: , ,