Fixed the Problem by rounding the result to a specified number of decimal places 20 in this case.
On 23 Sep., 09:44, Maik <[email protected]> wrote: > Hi ... I checked the types. > they are exactly set by type and I still don't know where there error > occurs > > It seems that the used Oracle.DataAccess-library isn't able to handle > the value returned by the oracle-function. > maybe too many decimal places? > > this may also be a topic for oracle support, isn't it? > > On 22 Sep., 23:04, Fabio Maulo <[email protected]> wrote: > > > Take because even the SetDecimal is wrong if the parameter is int. > > 2009/9/22 Maik <[email protected]> > > > > thanks... removed it... > > > these fragments remained from various experiments i tried before > > > asking the question here. > > > but it does not work at all > > > > On 22 Sep., 19:53, Fabio Maulo <[email protected]> wrote: > > > > Ah thanks.The solution is remove those "ToShortDateString". > > > > > 2009/9/22 Gustavo Ringel <[email protected]> > > > > > > The arithmetic operation has caused an overflow (using babylon :)) > > > > > > On Tue, Sep 22, 2009 at 6:42 PM, Fabio Maulo <[email protected]> > > > wrote: > > > > > >> Die arithmetische Operation hat einen Überlauf verursacht. > > > > >> in english ? > > > > > >> 2009/9/22 Maik <[email protected]> > > > > > >>> Hey guys, > > > > > >>> i don't get my native sql-query to work. > > > > >>> I hope you can help me. > > > > > >>> This is the code: > > > > > >>> var query = session > > > > >>> .CreateSQLQuery( "SELECT schema.function_name(:id, :from, :to) > > > > >>> bvi FROM dual" ); > > > > >>> query.SetDecimal( "id", fundId ); > > > > >>> query.SetDateTime( "from", from.ToShortDateString() ); > > > > >>> query.SetDateTime( "to", to.ToShortDateString() ); > > > > >>> query.List(); > > > > > >>> At the last step (executing the List()-method) I get the following > > > > >>> exception. > > > > > >>> 2009-09-22 12:42:55,266 [10] WARN > > > > >>> NHibernate.Util.ADOExceptionReporter [(null)] - > > > > >>> System.OverflowException: Die arithmetische Operation hat einen > > > > >>> Überlauf verursacht. > > > > >>> bei Oracle.DataAccess.Types.DecimalConv.GetDecimal(IntPtr numCtx) > > > > >>> bei Oracle.DataAccess.Client.OracleDataReader.GetDecimal(Int32 i) > > > > >>> bei Oracle.DataAccess.Client.OracleDataReader.GetValue(Int32 i) > > > > >>> bei Oracle.DataAccess.Client.OracleDataReader.get_Item(Int32 i) > > > > >>> bei NHibernate.Type.DecimalType.Get(IDataReader rs, Int32 index) > > > > >>> bei NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, > > > > >>> String > > > > >>> name) > > > > >>> bei NHibernate.Type.NullableType.NullSafeGet(IDataReader rs, > > > > >>> String > > > > >>> name, ISessionImplementor session, Object owner) > > > > >>> bei > > > > NHibernate.Loader.Custom.CustomLoader.ScalarResultColumnProcessor.Extract > > > > >>> (Object[] data, IDataReader resultSet, ISessionImplementor session) > > > > >>> bei > > > > NHibernate.Loader.Custom.CustomLoader.ResultRowProcessor.BuildResultRow > > > > >>> (Object[] data, IDataReader resultSet, Boolean hasTransformer, > > > > >>> ISessionImplementor session) > > > > >>> bei NHibernate.Loader.Custom.CustomLoader.GetResultColumnOrRow > > > > >>> (Object[] row, IResultTransformer resultTransformer, IDataReader rs, > > > > >>> ISessionImplementor session) > > > > >>> bei NHibernate.Loader.Loader.GetRowFromResultSet(IDataReader > > > > >>> resultSet, ISessionImplementor session, QueryParameters > > > > >>> queryParameters, LockMode[] lockModeArray, EntityKey > > > > >>> optionalObjectKey, IList hydratedObjects, EntityKey[] keys, Boolean > > > > >>> returnProxies) > > > > >>> bei NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, > > > > >>> QueryParameters queryParameters, Boolean returnProxies) > > > > >>> bei > > > > >>> NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections > > > > >>> (ISessionImplementor session, QueryParameters queryParameters, > > > Boolean > > > > >>> returnProxies) > > > > >>> bei NHibernate.Loader.Loader.DoList(ISessionImplementor session, > > > > >>> QueryParameters queryParameters) > > > > > >>> Exeuting the function in SQLPlus succeeds. > > > > > >>> Any hints how to solve this problem? > > > > > >>> Regards, > > > > >>> Maik > > > > > >> -- > > > > >> Fabio Maulo > > > > > -- > > > > Fabio Maulo > > > -- > > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
