Calling Database Package/Procedure in ADF

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);
    }