If the procedure has three parameters (one in, two out), then you need to call the procedure like this:
<procedure id="selectTargetMessages"
parameterMap="targetMessageParameters" remapResults="true">
{call pip_invc_msg_targ_chk (?,?,?)}
</procedure>
Jeff Butler
parameterMap="targetMessageParameters" remapResults="true">
{call pip_invc_msg_targ_chk (?,?,?)}
</procedure>
Jeff Butler
On 8/22/06, Brad Balmer <[EMAIL PROTECTED]> wrote:
I'm getting the following error:
Function doesn't have an output parameter or the out parameter isn't
returned.
How can I map multiple Strings coming back from a stord procedure?
<code>
public String[] selectTargetMessages(String pnOrdId) {
Map values = new HashMap(3);
values.put ("ordId", pnOrdId);
getSqlMapClientTemplate().queryForObject("customer.selectTargetMessages",
values);
String lsFirst = (String)values.get("first");
String lsSecond = (String)values.get("second");
String[] loResult = new String[2];
loResult[0] = lsFirst;
loResult[1] = lsSecond;
return(loResult);
}
<parameterMap id="targetMessageParameters" class=" java.util.HashMap" >
<parameter property="first" jdbcType="VARCHAR"
javaType="java.lang.String" mode="OUT"/>
<parameter property="second" jdbcType="VARCHAR"
javaType="java.lang.String" mode="OUT"/>
<parameter property="ordId" jdbcType="VARCHAR"
javaType="java.lang.String" mode="IN"/>
</parameterMap>
<procedure id="selectTargetMessages"
parameterMap="targetMessageParameters" remapResults="true">
{call pip_invc_msg_targ_chk (?)}
</procedure>
</code>
___________________________
Brad Balmer
Application Architect
Peapod, Inc.
847-583-6306
This email may contain confidential or legally privileged information
that is intended only for the individual or entity named as the
recipient. If you are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution, or reliance upon
the contents of this email is strictly prohibited. If you have received
this email in error, please contact the sender so that proper delivery
can be arranged, and then please delete this message. Thank you.
