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