While building a (new) ADF 11g application you sometimes have to deal with the fact that you have to use existing PL/SQL procedures for storing your data.

This article describes how you can overwrite your ADF business component’s default behavior to execute its DML statements using PL/SQL stored procedures.

 

There are a few steps we have to make:

  • Create a new Fusion Web Application and connect to the HR database
  • Create Entity and View for the REGIONS table (or based on a view if you like)
  • Create abstract class (PlSqlEntity.java) that will be the baseclass of all entities that use PL/SQL for its DML. This class will also contain a helper method for executing stored procedures
  • Make the REGIONS Entity extend our PlSqlEntity and implement the abstract methods
(more…)