I am trying to read data from oracle table into azure blob using copy activity. It throws ORA-01426 numeric outflow error. Any suggestions on how to get it resolved?

Question

I am trying to read data from oracle table into azure blob using copy activity. It throws ORA-01426 numeric outflow error. Any suggestions on how to get it resolved?

Particulary there is one column causing this issue. its data type in oracle is varchar(1024).

Answer 1

Hello Satwik Srivastava,

Greetings! Welcome to Microsoft Q&A Platform.

The ORA-01426 numeric overflow error typically occurs when a number is too large to be stored in the assigned data type. In the context of Azure’s copy activity from an Oracle table, this could happen if the data in a VARCHAR column is being implicitly converted to a numeric type and the value is too large for that numeric type.

There are some possible ways to resolve this error by validating the data in the problematic column to ensure that all values are within the expected range and format, especially if they’re being interpreted as numbers.

Ensure that there is no implicit conversion happening that might attempt to convert the VARCHAR data to a numeric type during the copy activity.

If the value of the blob is in an Oracle table and just want to copy that value to an azure blob storage or ADLS , I think you can use the copy activity and use Oracle as the sink and ADLS as source. You may need a query to pull the blob data on the Oracle side. Please do read more about the same here : https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle?tabs=data-factory, https://learn.microsoft.com/en-us/answers/questions/1053939/error-converting-data-type-varchar-to-numeric.

Hope this answer helps! Please let us know if you have any further queries. I’m happy to assist you further.

---

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.