Search: For:
Browsing Single Category

farewell to mod_plsql

Topic ID: 1596
Created By: 2007-FEB-07 13:50:56 [Vitaliy]
Updated By: 2007-FEB-07 13:55:41 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
5155
2007-FEB-07 13:50:56
Moderator
 
 
Registered On: Mar 2006
Total Posts: 195
May we say goodbye to mod_plsql as it vanishes from the Oracle Application 
Framework support in Release 12:

   Steven Chan: Release 12 will not support the use mod_plsql

Step into the clunky world of JDeveloper with it's Breakpoints and OA 
Extensions.  It is astonishing that while APEX is gaining a lot of traction the 
geniuses in ORACLE APPS Development decided that mod_plsql applications were 
not worthy of Oracle APPS Framework.

Do I care?  Yes I do, as an APPS DBA one of the things that always attracted me 
to mod_plsql based application was that the code existed solely in the 
database.  With the ever increasing number of components Oracle APPS brings to 
the table that alone was big help to those in the trenches, supporting this 
monster application.  By spreading components over multiple tiers debugging, 
tuning and customization will become even more complicated requiring more work 
and man hours to support the same application.

KISS - Keep It Simple Stupid NEVER applied to Oracle APPS but this move not 
only complicates things it puts most of the processing on the middle tier (JAVA 
layer) which is inheritably buggy, unstable and hard to diagnose as we learned 
during our 11.5.8 -> 11.5.10.2 upgrade:

   JSP Error fndvald.jsp
   APPS - java.lang.OutOfMemoryError
   Workflow Mailer: ClassDefFoundError

REFERENCE:
   Oracle Application Framework Release 11i Documentation Road Map (Metalink Note 275880.1)
[edited by: Vitaliy at 13:55 (CST) on Feb. 07, 2007]