Saturday, July 21, 2018

DB package calling at EOImpl class

    public HashMap getTrfVchnofromDbPkg(String compcode, String unitcode) {


        System.out.println("vchno from pkg");

        //String sqlproc2 = "{? = call adf_ess_leave_pkg.hdays_bw_dts_new2(?,?,?,?,?,?,?,?)}";
        String sqlproc2 = "{? = call pos_vchno_pkg.Get_Transfer_Vchno(?,? ,'XFR',462,19,?)}";
        CallableStatement sqlProcStmt2 = this.getDBTransaction().createCallableStatement(sqlproc2, 0);
        String v_dt1 = null;
        HashMap hm = new HashMap<String, Object>();

        try {

            sqlProcStmt2.registerOutParameter(1, Types.INTEGER);
            sqlProcStmt2.setString(2, compcode);
            sqlProcStmt2.setString(3, unitcode);
            //sqlProcStmt2.setString(4, vchcode);
            //sqlProcStmt2.setBigDecimal(5, vchid);
            //sqlProcStmt2.setString(6, finyrcode);
            sqlProcStmt2.registerOutParameter(4, java.sql.Types.VARCHAR);
            sqlProcStmt2.execute();

            Long v_ret_val = sqlProcStmt2.getLong(1);
            v_dt1 = sqlProcStmt2.getString(4);
            hm.put("VchPrefix", v_dt1);
            hm.put("TrfRefNo", v_ret_val);

            System.out.println("v_ret_val " + v_ret_val);
            //data_x_array[0] = v_ret_val;
            //data_x_array[1] = v_dt1;


        } catch (SQLException e) {

            System.out.println(e.getMessage());

        }

        return hm;
    }

No comments:

Post a Comment