Oracle Stored Procedure and Ibatisnet

[Jean Guillaume LALANNE]

Hi,   I am trying to use the following Oracle Stored Procedure with IbatisNet:   CREATE OR REPLACE FUNCTION DT_WIMB_INSERTHTTPREQUEST (   BROWSER IN TWIMB_HTTPREQUEST.HTTPREQUEST_BROWSER%TYPE,   IP IN TWIMB_HTTPREQUEST.HTTPREQUEST_IP%TYPE,   RTYPE IN TWIMB_HTTPREQUEST.HTTPREQUEST_TYPE%TYPE,   ENTITYNUM IN TWIMB_HTTPREQUEST.HTTPREQUEST_ENTITYNUM%TYPE,   STARTDATE IN TWIMB_HTTPREQUEST.HTTPREQUEST_STARTDATE%TYPE,   ENDDATE IN TWIMB_HTTPREQUEST.HTTPREQUEST_ENDDATE%TYPE,   RESULT IN TWIMB_HTTPREQUEST.HTTPREQUEST_RESULT%TYPE )  RETURN NUMBER   I have defined the following mapping xml file:   <parameterMap id="HTTPRequestParamMap" class="HTTPRequest">       <parameter property="Browser" column="BROWSER" dbType="VARCHAR"/>       <parameter property="Ip" column="IP" dbType="VARCHAR"/>       <parameter property="RType" column="RTYPE" dbType="VARCHAR"/>       <parameter property="EntityNum" column="ENTITYNUM" dbType="VARCHAR"/>       <parameter property="StartDate" column="STARTDATE" dbType="DATE"/>       <parameter property="EndDate" column="ENDDATE" dbType="DATE"/>       <parameter property="Result" column="RESULT" dbType="VARCHAR"/>  </parameterMap>   And statement:   <procedure id="setHTTPRequest" parameterMap="HTTPRequestParamMap" resultClass="System.Int32">       DT_WIMB_INSERTHTTPREQUEST </procedure>   And in my Dao object I am doing this:   <<  Object obj = ExecuteInsert("setHTTPRequest", httpRequest);   log.Debug(" result = " + obj );  >>   But it does not seem to work correctly. I get the following exception message:   <<  2005-01-24 10:08:07,918 [2328] DEBUG IBatisNet.DataMapper.Configuration.Statemen ts.PreparedStatementFactory [] <> - SQL for statement 'setHTTPRequest' :DT_WIMB_INSERTHTTPREQUEST   Exception non gérée : IBatisNet.Common.Exceptions.IBatisNetException: Error executing query 'setHTTPRequest' for insert.  Cause: Le format de la chaîne d'entrée est incorrect. ---> System.FormatException: Le format de la chaîne d'entrée est  incorrect.    at System.Number.ParseDecimal(String s, NumberStyles style, NumberFormatInfoinfo)    at System.Decimal.Parse(String s, NumberStyles style, IFormatProvider provider)    at System.Convert.ToDecimal(String value, IFormatProvider provider)    at System.String.System.IConvertible.ToDecimal(IFormatProvider provider)    at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) >>   Do anyone one of you know what I am doing wrong?   Thanks a lot for your help,   Regards   Jean-Guillaume LALANNE