I’m sharing a sample ADF BC application that uses stored procedures for reading and writing to the table.
Solution is simple and straight forward...
1. Create an EntityObject and override the below methods
Please refer the below topic in Fusion Developer's Guide to learn more …
protected void doSelect(boolean lock) protected void doDML(int operation, TransactionEvent e)
38.5 Basing an Entity Object on a PL/SQL Package API
2. Define a ViewObject based on the above EntityObject. Override the below 'life cycle methods' to inject your custom code(for populating data form a REF CURSOR).
protected void create() protected void executeQueryForCollection(Object qc, Object params, int numUserParams) protected ViewRowImpl createRowFromResultSet(Object qc, ResultSet rs) protected boolean hasNextForCollection(Object qc) protected ViewRowImpl createRowFromResultSet(Object qc, ResultSet rs) protected void releaseUserDataForCollection(Object qc, Object rs)
Please refer the below topic in Fusion Developer's Guide to learn more…
39.8 Using Programmatic View Objects for Alternative Data Sources
You can download the sample workspace from here.
[Runs with Oracle JDeveloper 11g R1 PS1]
PS: Unzip the attachment and run the script(StoredProcedureExample/script) to set up the required DB objects for running this demo
Learn More ...
There are a lot more points like this. If you are curious to learn the internals of the ADF Business Components and ADF Binding Layer, the following book is for you - Oracle ADF Real World Developer’s Guide.
More details about this book can be found in this post- http://jobinesh.blogspot.in/2012/07/pre-order-your-copy-of-oracle-adf-real.html