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 > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
