Guest User

Untitled

a guest
Sep 11th, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 5 0.73 KB | None | 0 0
  1. String procedureName = "SWBAPPS.PC_INTERFACE_PORTAL_CTBC_2.PR_INFO_REPARO"
  2.                  + parameterService.getValue(PortalParametros.DBLINK_CRM_KEY);
  3. List<ProcedureParameter> parameters = new ArrayList<ProcedureParameter>();
  4.  
  5. parameters.add(new ProcedureParameter(InOut.IN, Types.VARCHAR, "1", acao));
  6. parameters.add(new ProcedureParameter(InOut.IN, Types.VARCHAR, "2", codPai));
  7.  
  8. parameters.add(new ProcedureParameter(InOut.OUT, OracleTypes.CURSOR, "outCursor"));
  9. parameters.add(new ProcedureParameter(InOut.OUT, Types.NUMERIC, "outCod"));
  10. parameters.add(new ProcedureParameter(InOut.OUT, Types.VARCHAR, "outMsg"));
  11.  
  12. RetornoOpcaoBean bean = new RetornoOpcaoBean();
  13. Map<String, Object> a = procedureCallerDAO.executeProcedure(procedureName, parameters);
Add Comment
Please, Sign In to add comment