Skip to content

SQL Jana

Jana's ramblings on SQL Server, Oracle, PowerShell and technology

Tag: Arithmetic Operation Overflow

Oracle ODP.NET: Resolve “Arithmetic operation resulted in an overflow” or “Specified cast is not valid”

Oracle ODP.NET: Resolve “Arithmetic operation resulted in an overflow” or “Specified cast is not valid”

This is similar to "Oracle Nasty Dates Finder for .NET folks!" but this time it is for numbers instead of dates! I ran into this issue as I was moving data from Oracle to SQL Server. So, you are working with Oracle using ODP.NET and you have a simple, straight-forward SELECT * FROM TABLE; Alternatively, … Continue reading Oracle ODP.NET: Resolve “Arithmetic operation resulted in an overflow” or “Specified cast is not valid”

Posted on February 20, 2020March 5, 2020 by SQLJanaPosted in .Net, ADO.NET, C#, ODP.Net, Oracle, PLSQL, TablesTagged Analytic Functions, Arithmetic Operation Overflow, CAST, Cast Invalid, Columns, DBA_TAB_COLUMNS, Decimal Places, Decimals, Finder, Fit, Fix, Float, Generic Solution, LISTAGG, Meta-Data, Number, Numeric, Numeric Columns, ODP.Net, Oracle, Oracle.DataAccess, Oracle.ManagedDataAccess, PARTITION BY, Precision, Problem Finder, Query, ROUND, ROUNDING, ROW_NUMBER, SQL, Too Big, Truncate, Windowing Functions. Leave a comment

Categories

Unknown's avatar

Enter your email address to follow this blog and receive notifications of new posts by email.

Follow SQL Jana on WordPress.com

Tags

Active Directory AD Backup Backups Capture Code Column CommandLine COMMIT Compare COPY Database Databases DateTime Days DBA dbatools DDL Delete Differences DML Duration Dynamic SQL Error Errors Example Examples Fast File Files Filter FULL TABLE SCAN Generate Indexes INSERT Install Login LOOP Match Oracle Oracle Tip Output Parallel Performance Permissions PIVOT PLSQL PowerShell Query Replace ROLLBACK Search SELECT Servers Size SQL SQL*Plus SQLPS SQL Server SQLServer SQL Server Tip SSMS Status Stored Procedure Table Tables TempDB Tip Transaction TSQL UNDO Update Usage USER Windows

Recent Posts

  • PowerShell & SQL Server – Compare Configuration of Two SQL Server Instances July 24, 2024
  • PowerShell: Script Out SQL Server Objects DDL To Folder Using dbatools May 10, 2024
  • SQL Server: Copy Data from Large Tables to Target in a Resumable Fashion! February 6, 2024
  • PowerShell & SQL Server: Unmask All Masked Columns (Dynamic Data Masking) In Database March 16, 2023
  • PowerShell: How To Reverse Alphabetical File Names & Rename December 17, 2022

Top Posts & Pages

  • SQL Server: Fix: Transaction (Process ID) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction
  • Oracle: Find The Total Size Of All Of Your CLOB & BLOB Columns In All Tables
  • Oracle Tip - EXECUTE IMMEDIATE With Bind Variable Input In Dynamic SQL
  • SQL Server - Drop An User In All Databases & Drop The Login Too!
  • MySQL: Fix MySQL Error 2026 (HY000): SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol
  • Thoughts On When To Use - Write-Host, Write-Output, Write-Debug, Write-Warning, Write-Verbose & Write-Error/Throw
  • Eating An Elephant - How To Work With Huge Datasets In Oracle And SQL Server
  • SQL Server: Delete In Chunks To Avoid Log Growth
  • SQL Server: Fix - The server principal "elevated_user_login" is not able to access the database "my_database" under the current security context
  • SQL Server - Space - Data And Log File Growth Auto-Grow History TSQL

Archives

  • July 2024 (1)
  • May 2024 (1)
  • February 2024 (1)
  • March 2023 (1)
  • December 2022 (1)
  • November 2022 (2)
  • October 2022 (1)
  • April 2022 (1)
  • April 2021 (1)
  • November 2020 (1)
  • October 2020 (2)
  • September 2020 (1)
  • June 2020 (1)
  • May 2020 (2)
  • April 2020 (1)
  • March 2020 (2)
  • February 2020 (2)
  • November 2019 (1)
  • September 2019 (1)
  • July 2019 (2)
  • April 2019 (1)
  • March 2019 (3)
  • February 2019 (1)
  • November 2018 (1)
  • September 2018 (1)
  • August 2018 (1)
  • April 2018 (5)
  • March 2018 (3)
  • February 2018 (5)
  • January 2018 (6)
  • December 2017 (1)
  • October 2017 (1)
  • September 2017 (2)
  • August 2017 (4)
  • July 2017 (2)
  • June 2017 (3)
  • May 2017 (1)
  • April 2017 (11)
  • March 2017 (14)
  • February 2017 (23)
  • January 2017 (31)
  • December 2016 (10)
  • November 2016 (1)
  • October 2016 (3)
  • April 2016 (1)
  • March 2016 (1)
  • January 2016 (1)
  • November 2015 (2)
  • October 2015 (3)
  • September 2015 (1)
  • August 2015 (4)
  • July 2015 (1)
  • April 2015 (1)
  • December 2014 (1)
  • March 2014 (6)
  • February 2014 (1)
  • August 2012 (3)
  • October 2011 (1)
  • March 2011 (1)
  • February 2011 (1)
  • January 2011 (2)
  • December 2010 (2)

Follow me on Twitter

My Tweets
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • Image SQL Jana
    • Join 154 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Image SQL Jana
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...
 

    Design a site like this with WordPress.com
    Get started
    Advertisement