title: Oracle: Arithmetic operation resulted in an overflow
body: <p>My query pulls two strings - no numeric types at all, yet the Oracle client gives me the exception above.  Any ideas?</p>
  
  <p>Here is the query - all fields are strings:</p>
  
  <pre><code> SELECT project_name 
          , project_title
          , project_name as Job2   
          , project_name as Job1  
   FROM PROJ
  </code></pre>
  
  <p>Here is the exception:</p>
  
  <pre><code>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&amp; dataSet, IDbCommand command, String[] tableNames) in c:\Dropbox\svn\partners\libraries\internal\Partners.Core\Data\Database.cs:line 999
  </code></pre>