Thanks.
Right before I received this I was told that I needed to call this SP
just like calling any normal SQL select statement. Now I've got to
figure out how to do that.
Jeff Butler wrote:
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
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.
--
___________________________
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.
|
- Re: Call Stored Procedure Returning Multiple Values Brad Balmer
-
