数学溢出Oracle,c# – Oracle：算术运算导致溢出

最新推荐文章于 2023-11-17 11:44:58 发布

孤独的根号三

最新推荐文章于 2023-11-17 11:44:58 发布

阅读量500

点赞数

文章标签：数学溢出Oracle

我的查询提取了两个字符串 – 根本没有数字类型,但Oracle客户端给了我上面的例外.有任何想法吗？

这是查询 – 所有字段都是字符串：

SELECT project_name

, project_title

, project_name as Job2

, project_name as Job1

FROM PROJ

这是一个例外：

System.OverflowException: Arithmetic operation resulted in an overflow.

at System.Data.Odbc.OdbcDataReader.FirstResult()

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)

at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)

at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

at Partners.Core.Data.Database.FillDataSet(DataSet& dataSet, IDbCommand command, String[] tableNames) in c:\Dropbox\svn\partners\libraries\internal\Partners.Core\Data\Database.cs:line 999