ProcedureDao { public List<Procedure> getAllSimpleFunctionAndProcedure(String owner, String projectName, String sourcesTable) { return jdbcTemplate.query( getAllSimpleFunctionAndProcedureQuery(projectName, sourcesTable), (resultSet, i) -> new Procedure.Builder() .objectName("") .procedureName(resultSet.getString("object_name")) .overload(resultSet.getString("overload") == null ? "" : resultSet.getString("overload")) .methodType(resultSet.getInt("proc_or_func") == 0 ? "PROCEDURE" : "FUNCTION") .argumentList(getProcedureArguments("", resultSet.getString("object_name"), resultSet.getString("overload"), owner)) .build(), owner, owner, owner ); } 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 testGetAllSimpleProcedureAndFunction() { List<Procedure> procs = procedureDao.getAllSimpleFunctionAndProcedure("OBRIDGE", null, null); System.out.println(procs); }