For stored procedure calls that return a value, don't we have to use
JDBC syntax like this:
{? = call EKA.SISTEM_KONTROL_SPAJ.GENERATE_COUNTER (?,?,?,?,?,?)}
The leading ? receives the value. Perhaps this is why "result" and
"hasil" have no value. Replace the ?'s with your iBATIS parameters
and it might work.
Ted
On 22/02/07, Yusuf <[EMAIL PROTECTED]> wrote:
Hi all,
Sorry for the misunderstanding, but it was just a problem of copy and
paste.. (because before i tried using parameters passed as raw
HashMap).. actually i had this :
<procedure id="elions.bas.procCounter"
parameterMap="elions.bas.procCounter.param">
but still the same problem.. oh and to Mr. Larry, I think the "."
characters in the name is no problem, because i've been coding ibatis
sqlmaps like that for quite some time (i know it's better using
namespaces.. but we're a little occupied now to fix it)
thank you... and please CMIIW..
yusuf
-----Original Message-----
From: Larry Meadors [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 22, 2007 12:37 PM
To: [email protected]
Subject: Re: Just Another Stored Procedure Question
You misread Brad's comment, i think.
You have this:
<procedure id="elions.bas.procCounter" parameterClass="hashMap">
You need to have this:
<procedure id="elions.bas.procCounter"
parameterMap="elions.bas.procCounter.param">
..which may still not work because of the "." characters in the name.
Larry
