Wednesday, March 16, 2011

ADF BC PLSQL Entity support

A PL/SQL based entity object provides an object representation of the data from a table or view and routes the DML (update, insert,delete, and lock) operations to stored procedures in the database. It must extend the class oracle.apps.fnd.applcore.oaext.model.OAEntityImpl and set the Applcore schema based property fnd:OA_PLSQL_ENTITY to "Y" and then override any of the following methods for its DML operations and provide JDBC calls when applicable (make sure not to call super in your implementation).

void insertRow();
void updateRow();
void deleteRow();

You should use the PL/SQL EOs only if you have legacy PL/SQL code that maintains all your transactions and validations. If you are a new product and/or do not have a lot of PL/SQL legacy code, Applcore recommends the use of Java EOs over PL/SQL EOs.

No comments:

Post a Comment