final ProcedureParameter paramRd = new ProcedureParameter();
final ProcedureParameter paramRd = new ProcedureParameter();
List<ProcedureParameter> columns = new ArrayList<ProcedureParameter>(uuids.size()); for (String uuid : uuids) { ProcedureParameter column = new ProcedureParameter(); column.setUUID(uuid); columns.add(column);
List<ProcedureParameter> columns = new ArrayList<ProcedureParameter>(uuids.size()); for (String uuid : uuids) { ProcedureParameter column = new ProcedureParameter(); column.setUUID(uuid); columns.add(column);
/** * Add a procedure parameter. * @param name * @param type should be one of {@link TypeFacility.RUNTIME_NAMES} * @param parameterType should be one of {@link ProcedureParameter.Type} * @param procedure * @return * @throws MetadataException */ public ProcedureParameter addProcedureParameter(String name, String type, ProcedureParameter.Type parameterType, Procedure procedure) { ProcedureParameter param = new ProcedureParameter(); if (renameAllDuplicates) { name = checkForDuplicate(name, (s)->procedure.getParameterByName(s) != null, "Parameter"); //$NON-NLS-1$ } param.setName(name); setUUID(param); param.setType(parameterType); param.setProcedure(procedure); setDataType(type, param, this.dataTypes, false); if (parameterType == Type.ReturnValue) { procedure.getParameters().add(0, param); for (int i = 0; i < procedure.getParameters().size(); i++) { procedure.getParameters().get(i).setPosition(i+1); //1 based indexing } } else { procedure.getParameters().add(param); param.setPosition(procedure.getParameters().size()); //1 based indexing } return param; }
/** * Create stored procedure parameter. */ public static ProcedureParameter createParameter(String name, int direction, String type) { ProcedureParameter param = new ProcedureParameter(); param.setName(name); switch (direction) { case SPParameter.IN: param.setType(Type.In); break; case SPParameter.INOUT: param.setType(Type.InOut); break; case SPParameter.OUT: param.setType(Type.Out); break; case SPParameter.RESULT_SET: throw new AssertionError("should not directly create a resultset param"); //$NON-NLS-1$ case SPParameter.RETURN_VALUE: param.setType(Type.ReturnValue); break; } param.setRuntimeType(type); return param; }