@Service("testDao")
@Transactional(timeout = 300)
public class TestDaoImpl implements TestDao {
    @Autowired(required = true)
    private DataSource ds;
    @Autowired
    private JdbcTemplate jt;
    private SimpleJdbcCall simpleJdbcCall;
    public void setDataSource(DataSource ds) {
        this.ds = ds;
    }
    @Override
    public List < TestBean > Issue(
List < TestBean > data, HttpServletRequest req) {
        List < TestBean > ResponceList = new ArrayList < TestBean > ();
        String member_code = "";
        this.simpleJdbcCall = new SimpleJdbcCall(ds)
            .withSchemaName("TEST")
            .withCatalogName("TEST_PKG")
            .withProcedureName("TEST_DATA")
            .declareParameters(new SqlParameter("p_test_list",
            OracleTypes.ARRAY, "TEST_LIST"),
                new SqlOutParameter("p_test_result_list",
                OracleTypes.ARRAY, "TEST_RESULT_LIST"));
        Connection con = null;
        try {
            con = dataSource.getConnection();
            SqlParameterSource in = new MapSqlParameterSource()
                .addValue("p_test_list", arrayOfProjects, OracleTypes.ARRAY);
            Map < String, Object > out = simpleJdbcCall.execute( in );
            Array outlistObjectArray = (Array) out
                .get("p_test_result_list");
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                con.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return ResponceList;
    }
}