OCI-22053: Overflow Error

[joaoluizbt]

Good afternoon,

I have a class that searches for the information of a table, but when this search is made, it gives Stack Overflow error ... but the table only has a line, should not Give this mistake, right?

follows the code:

Class code:

Select all

public DataSet RetornaDataSet(string strQuery) 
            { 
            OracleConnection cn = new OracleConnection(); 
            try  
            	{	     
                cn = Abriconexao(); 
                OracleCommand cmd = new OracleCommand(); 
                cmd.CommandText = strQuery.ToString(); 
                cmd.CommandType = CommandType.Text; 
		        cmd.Connection = cn; 
                cmd.ExecuteNonQuery(); 
                /*  Declarado um dataadapter e um dataset 
                    passar o comando para o da (SqlDataAdapter) e  
                    carregar o dataset com resultado da busca */ 
                OracleDataAdapter da = new OracleDataAdapter(); 
                DataSet ds = new DataSet(); 
                da.SelectCommand =  cmd; 
 
                da.Fill(ds); // O ERRO DÁ AQUI, NO PREENCHIMENTO. 
 
                return ds; 
            	} 
            
            finally 
            { 
                FecharConexao(cn); 
            } 
 
            }

Thanks.

[stcoutinho]

Joao,

I do not know if this forum would be the most suitable for your question.
But if you search for Google by OCI-22053, you will find multiple reports with this type of problem, involving the Oracle database.
As I could understand these articles, a problem may be occurring in the conversion of numeric fields with decimal places (eg Number (15.4)), which would be generating this overflow error.
Your table of a line seizures Number (N, D) fields?
In this case, which most articles recommended was to resort these fields in the execution of the SELECT command.

Specifically it was recommended that

Select all

TRUNC([nome_do_campo],2)

Select all

TRUNC([nome_do_campo],2)

in Select to "round" these fields with many decimal places.

Ex:

Select all

TABELA_A (VALOR NUMBER(14,5)) 
SELECT TRUNC(VALOR,2) FROM TABELA_A;

I hope this information helps you in solving the problem.

Hugs,

Sergio

[dr_gori]

Topic moved to Java ...

[victorhugomuniz]

Possibly the error does not give in this line .. I understand that your IDE is pointing at her but stackoverflow is a masked mistake .. Your real error is likely to be

What does this line do?

Select all

da.SelectCommand =  cmd; 

I think you are mixing a few things there .. are you really using Java?

[joaoluizbt]

Ola,

The problem was the houses after the virgulum.
After I gave a trunced it worked ..

Thank you very much.

[Renato Menezes Viana]

Personally, getting into the subject, the link below demonstrates how to pick up the error description (SQLERRM) in Java.
http://docstore.mik.ua/orelly/oracle/gu ... h09_08.htm
It seems that existing in the Java code the line below, always a very enlightening error message will appear.

Select all

} catch (SQLException e) {System.err.println(e.getMessage());}

I kicked or right?