Define execute procedure Operation in Application Module Impl:
import java.sql.Types;
import oracle.jdbc.OracleCallableStatement;
public String executeProc(String value1,String value2,String value3) {
String output=null;
Connection conn;
try {
conn = getDBTransaction().createStatement(1).getConnection();
String executeProcStatement=
"begin SAMPLE_PKG.SAMPLE_PROC(:inputParam1," +
":inputParam2,"+
":inputParam3," +
":outputParam1," +
":outputParam2);
end;";
CallableStatement st = null;
st =
getDBTransaction().createCallableStatement(executeProcStatement, this.getDBTransaction().DEFAULT);
try{
st =
(OracleCallableStatement)getDBTransaction().createCallableStatement(executeProcStatement,0);
st.setObject("inputParam1", value1);
st.setObject("inputParam2", value2);
st.setObject("inputParam3", value3);
st.registerOutParameter("outputParam1", Types.VARCHAR);
st.registerOutParameter("outputParam2", Types.VARCHAR);
st.execute();
output=(String)st.getObject("outputParam1");
System.out.println(st.getObject("outputParam1"));
}catch (SQLException e) {
.....................................................
} finally {
if (st != null) {
try {
st.close();
} catch (SQLException e) {
.....................................................
}
}
}
}
catch (SQLException e) {
System.out.println(e);
}
return output;
}
Define Method in backing or managed bean and specify it in ADF faces components action listener property:
public void executeProcListener(ActionEvent actionEvent) {
OperationBinding executeProc = ADFUtils.findOperation("executeProc");
Map params=executeProc.getParamsMap();
params.put("inputParam1", value1);
params.put("inputParam2", value2);
params.put("inputParam3", value3);
String output=(String)executeProc.execute();
FacesContext fc=FacesContext.getCurrentInstance();
if(output!=null) {
.................................................
}
else
{
.................................................
}
log.severe("Output "+output);
}