OCI-22053: overflow error - C #

0

I'm developing a web application in MVC with C# . I made a method that makes a select in my bank and with the value returned I fill in a DataTable . But it returns an error when I run " dataAdapter.Fill(resultado) " returning error:

  

OCI-22053: overflow error .

Does anyone know the reason for this error?

Follow method code:

public DataTable ResgataArquivos()
{
    var resultado = new DataTable();

    myConnection.ConectarBanco(modelLogin);

    var query = "SELECT * FROM ARQUIVO";

    var command = new OracleCommand(query, myConnection.connection);
    var dataAdapter = new OracleDataAdapter(command); 
    dataAdapter.Fill(resultado);

    myConnection.FecharConexaoBanco();

    return resultado;
}
    
asked by anonymous 12.02.2014 / 13:30

1 answer

2

I have researched here about this error and in most cases the problem was because of some column that was NUMBER(N,D) error occurring in the conversion of these values, it may happen that there are other fields that also exceeded the limit at the time of the conversion so take a look at your existing data.

Try giving TRUNC if you have any such columns.

"SELECT TRUNC(VALOR,2) FROM Arquivo"


People with this same problem: 1 , 3 .

    
12.02.2014 / 13:36