Shell Programming and Scripting

Here is part of my program code:

#Collect the output of test database and count the no
#of rows too
while(my @array = $tstDbStatementHandle->fetchrow_array)
{
push @tstDbOutputArray,[ @array ];
$tstDbOutputRows++;
}

-------------------------------------------------------------------------------------------------------------------------------

I am unable to retrieve data from the Oracle database. The error which i am getting is
"DBD::ODBC::st fetchrow_array failed: [unixODBC][Oracle][ODBC]Numeric value out of range"

I have tried binding the values but still the application is throwing the sam error.The data which the application is trying to retrieve contain huge numeric values.

Any solution buddies?????

Thanx in advance.........

This is an SQL error, and has nothing with this particular Perl code to do. Googling for this error message suggests a mismatch between what's actually in the tables and what you are declaring it should be. Could be a bug in the actual ODBC code too; see e.g. RE: Numeric value out of range error

Well, at last found out that Perl is unable to handle data value beyond "9219999999900004864". I am using Perl 5.8 and DBI 1.604

Can you use the BigInt Perl module?