result.setAttachment(attachment);
}
for (DbStoredArgument arg : storedProcedure.getArguments()) {
String argName = arg.getName();
if (argName != null) {
ProcedureArgument pa = null;
Parameter parm = null;
InOut direction = arg.getInOut();
QName xmlType = null;
switch (arg.getJdbcType()) {
case STRUCT:
case ARRAY:
case OTHER:
String typeString =
builder.topTransformer.generateSchemaAlias(arg.getJdbcTypeName());
xmlType = buildCustomQName(typeString, builder);
break;
default :
if (isOracle) {
xmlType = OracleHelper.getXMLTypeFromJDBCType(
arg, builder.getTargetNamespace());
}
else {
xmlType = getXMLTypeFromJDBCType(arg.getJdbcType());
}
break;
}
if (direction == IN) {
parm = new Parameter();
parm.setName(argName);
parm.setType(xmlType);
pa = new ProcedureArgument();
pa.setName(argName);
pa.setParameterName(argName);
if (qh instanceof StoredProcedureQueryHandler) {
((StoredProcedureQueryHandler)qh).getInArguments().add(pa);
}
}
else {
// the first OUT/INOUT arg determines singleResult vs. collectionResult
pa = new ProcedureOutputArgument();
ProcedureOutputArgument pao = (ProcedureOutputArgument)pa;
pao.setName(argName);
pao.setParameterName(argName);
if (arg.getJdbcTypeName().contains("CURSOR") &&
returnType == null) { // if user overrides returnType, assume they're right
pao.setResultType(SXF_QNAME_CURSOR);
if (result == null) {
result = new CollectionResult();
result.setType(SXF_QNAME_CURSOR);
}
}
else {
// if user overrides returnType, assume they're right
// Hmm, multiple OUT's gonna be a problem - later!
if (returnType != null && sxf == null) {
xmlType = qNameFromString("{" + builder.getTargetNamespace() + "}" +
returnType, builder.schema);
}
pao.setResultType(xmlType);
if (result == null) {
if (isCollection) {
result = new CollectionResult();
}
else {
result = new Result();
}
result.setType(xmlType);
}
}
if (direction == INOUT) {
if (qh instanceof StoredProcedureQueryHandler) {
((StoredProcedureQueryHandler)qh).getInOutArguments().add(pao);
}
}
else {
if (qh instanceof StoredProcedureQueryHandler) {
((StoredProcedureQueryHandler)qh).getOutArguments().add(pao);
}
}
}
if (arg instanceof PLSQLStoredArgument) {
pa.setComplexTypeName(((PLSQLStoredArgument)arg).getPlSqlTypeName());
}
if (parm != null) {
qo.getParameters().add(parm);
}
}