ProcedureDao { public List<ProcedureArgument> getProcedureArguments(String packageName, String procedureName, String overLoadNo, String owner) { return jdbcTemplate.query( GET_PROCEDURE_ARGUMENTS, new Object[]{owner, owner, packageName, procedureName, overLoadNo}, (resultSet, i) -> new ProcedureArgument( resultSet.getString("argument_name"), resultSet.getString("data_type"), resultSet.getString("type_name"), resultSet.getString("in_out").contains("IN"), resultSet.getString("in_out").contains("OUT"), resultSet.getString("orig_type_name") ) ); } ProcedureDao(DataSource dataSource); List<Procedure> getAllProcedure(String nameFilter, String owner, String projectName, String sourcesTable); List<Procedure> getAllSimpleFunctionAndProcedure(String owner, String projectName, String sourcesTable); List<Procedure> getAllProcedure(String packageName, String procedureName, String owner, String projectName, String sourcesTable); List<ProcedureArgument> getProcedureArguments(String packageName, String procedureName, String overLoadNo, String owner); List<OraclePackage> getAllPackages(String nameFilter, String owner, String projectName, String sourcesTable);  }
@Test public void testGetProcedureArguments() { List<OraclePackage> allPackages = procedureDao.getAllPackages(null, "OBRIDGE", null, null); Assert.assertTrue(allPackages.size() > 0); for (OraclePackage p : allPackages) { MustacheRunner.build("package.mustache", p); } }
@Test public void getProcedureArguments() { final List<ProcedureArgument> procedureArguments = procedureDao.getProcedureArguments("NULLITY_CHECK", "CHECK_OUT_NULL_LIST", null, "OBRIDGE"); Assert.assertEquals(1, procedureArguments.size()); Assert.assertEquals("P_LIST_OBJECT", procedureArguments.get(0).getArgumentName()); }