Posts tagged BC
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