This content has been marked as final. Show 6 replies
Hi JP,1 person found this helpful
While creating Entity Object EO, it will allow you to select only one data base object ( table ) at design time .
How ever you can insert record into different tables using Prepared statement .
Please Let us know clearly what exactly your requirement is ?
Requirement is we are having 6 different tables.
User have choices like update/delete/Insert on selected table among 6 tables.
Depending on this user choice, we need to perform DML on the selected table.
This is possible with single EO?
as per your suggestion, we use the prepared statement.
Hi,1 person found this helpful
You can create a PL/SQL procedure for performing DML operating and your logic inside that.
Later you can use CallableStatement to execute that procedure.
Hi JP ,1 person found this helpful
It is not possible with a single EO , how ever from controller class you can call a Database procedure that performs
DML operation for 6 different table .
As shushant said you can make use of CallableStatement .
...1 person found this helpful