Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: neutral (asf.osuosl.org: local policy)
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: stored procedures/functions
Date: Thu, 11 Aug 2005 17:00:25 +0530
Message-ID: <A8186A64C6307940AB43CFFA85397D4039AE85@IND-MHP1ECL001.mastek.com>
Thread-Topic: stored procedures/functions
Thread-Index: AcWeZ71rReMXrYkmTEej0c1aFjpAmQAAEIMw
From: "Priyesh Mashelkar" <priyeshm@mastek.com>
To: <user-java@ibatis.apache.org>

jdbcType should be VARCHAR and not VARCHAR2 i suppose.

-----Original Message-----
From: Denis Vladimirov [mailto:denis.vladimirov@gmail.com]
Sent: Thursday, August 11, 2005 4:58 PM
To: user-java@ibatis.apache.org
Subject: stored procedures/functions


Hi there,
I am trying to make a call to a stored Oracle function and I get the
following error.
What am I doing wrong?
Or what is the best and simple way to call stored functions?

Error
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
The error occurred while executing query procedure.
--- Check the {? =3D call parameter.get_string(?)}.
--- Check the output parameters (register output parameters failed).
--- Cause: java.sql.SQLException: Invalid column type; nested
exception is com.ibatis.common.jdbc.exception.NestedSQLException:
---

My Xml file
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
<parameterMap id=3D"getStringParameterMap" class=3D"java.util.Map">
       <parameter property=3D"result" jdbcType=3D"VARCHAR2"
javaType=3D"java.lang.String" mode=3D"OUT" />
<parameter property=3D"param_name" jdbcType=3D"VARCHAR2"
javaType=3D"java.lang.String" mode=3D"IN" />
   </parameterMap>

   <procedure id=3D"getStringParameter" parameterMap=3D"getStringParameterM=
ap">
       {? =3D call parameter.get_string(?)}
   </procedure>


My Java src
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
               Map map =3D new HashMap();
               map.put("result", "");
               map.put("param_name ", parameter);
               result =3D (String) getSqlMapClientTemplate().queryForObject(
                               "getStringParameter", map);
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Thanks,
Denis


MASTEK
"Making a valuable difference"
Mastek in NASSCOM's 'India Top 20' Software Service Exporters List.
In the US, we're called MAJESCO

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions expressed in this e-mail are those of the individual and not that =
of Mastek Limited, unless specifically indicated to that effect. Mastek Lim=
ited does not accept any responsibility or liability for it. This e-mail an=
d attachments (if any) transmitted with it are confidential and/or privileg=
ed and solely for the use of the intended person or entity to which it is a=
ddressed. Any review, re-transmission, dissemination or other use of or tak=
ing of any action in reliance upon this information by persons or entities =
other than the intended recipient is prohibited. This e-mail and its attach=
ments have been scanned for the presence of computer viruses. It is the res=
ponsibility of the recipient to run the virus check on e-mails and attachme=
nts before opening them. If you have received this e-mail in error, kindly =
delete this e-mail from all computers.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~