Procedure calling in Oracle ADF
Wednesday, April 22nd, 2009In Oracle Adf we will doing DML operation by calling the Procedure.Here the syntax of calling
Stored procedure is as follow:
Here Procedure name is — Vinayprocedure(empno,job,name)
StoredProcedureCall call = new StoredProcedureCall();
call.setProcedureName("Vinayprocedure");
call.addUnamedArgument("empno");
call.addUnamedInOutputArgument("job", "job", String.class);
call.addUnamedOutputArgument("name");
DataModifyQuery query = new DataModifyQuery();
query.setCall(call);
query.addArgument("empno");
query.addArgument("job");
query.addArgument("name");
session.addQuery("Vinayprocedure ", query);
Vector parameters = new Vector();
parameters.addElement(new Integer(7369));
parameters.addElement("engineer");
parameters.addElement("Vinay");
Object data = session.executeQuery(query, parameters);
When we are calling data from some view object, [...] Read more »
Partial Page Rendering (PPR) In Oracle ADF
Saturday, March 14th, 2009PPR is Partial Page Rendering, similarly to Ajax. It is used to dynamically refresh the part of page.It is done with the use of partial triggers.
For better understanding , i will explain by an example.
In Any .jspx page we have one table (table1) and one command button(button1) label ‘Delete’. On clicking the Delete
button it will [...] Read more »
OAF versus ADF
Sunday, March 8th, 2009OAF versus ADF
I have seen many forums asking about Difference between OAF and ADF. May be my post will clear some points on this
OAF – OAF is a framework for extending Oracle E-Business Suite. If you want to customize and Oracle EBS system you need to use OAF. OAF is a e-biz web development framework [...] Read more »