About Using Stored Procedures

You can override the doDML() method of any Entity Object's EntityImpl class to invoke a PL/SQL Stored Procedure, instead of using the default DML. PL/SQL stored procedures are useful when your updates are complex and involve multiple tables instead of a simple update to a single table.

Your stored procedure can perform an update, insert, or delete instead of the default framework behavior of applying the appropriate UPDATE, INSERT, or DELETE statement on your Entity Object's behalf.