DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r
# 1  
Old 04-04-2008
Bug DBD::ODBC::st fetchrow_array failed: [unixODBC][Oracle][ODBC]Numeric value out of ran

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 ];


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.........

Last edited by sameerstephen; 04-04-2008 at 02:52 AM..
# 2  
Old 04-05-2008
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
# 3  
Old 04-16-2008
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
# 4  
Old 04-16-2008
Can you use the BigInt Perl module?
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Solaris

odbc libraries

Hi, this is my first experience with Solaris. For work, I must configured an applicacion (oracle EPM, this include Datadirect odbc drivers) in solaris. Additionally, we must connect to Sybase IQ Database (I installed odbc drivers to do this). The problem is, I can't get those two odbc... (1 Reply)
Discussion started by: dmedinacl
1 Replies

2. Shell Programming and Scripting

Connecting to Oracle by using ODBC on UNIX

Hi All, I have a requirement where I need to connect to Oracle database which is installed on WINDOWS machine. I dont have Oracle client installed on my AIX so i can't use SQLPLUS command. But ODBC to connect to Oracle is configured on my UNIX server. Can any one help me with the steps of... (1 Reply)
Discussion started by: Raamc
1 Replies

3. AIX


I´m using an app that uses odbc to connect to the data base, i thought odbc was only available for NT plataforms...anybody knows how to create an odbc connection on AIX 5.1 (if possible). Thanks a lot (3 Replies)
Discussion started by: paulcarbajal
3 Replies

4. Windows & DOS: Issues & Discussions

Oracle 9i ODBC connection

I am attempting to access an Oracle 9i database located on a Solaris server from an XP client. The server is running Oracle 9i9. and the XP is Oracle client 9i When I start a listener on the server, the listener starts but I receive a message “The listener supports no services”. I... (3 Replies)
Discussion started by: jkuchar747
3 Replies

5. UNIX for Dummies Questions & Answers


I see several questions regarding setting up ODBC on UNIX machines but I don't see any replies. I always thought ODBC was only possible on Windows machines, but I've recently heard drivers do exist for ODBC on UNIX. Does anyone know any more details about this: How to set up ODBC on UNIX, web sites... (1 Reply)
Discussion started by: ggmar
1 Replies

6. UNIX for Dummies Questions & Answers

ODBC Version

how to find the version of ODBC and the database drivers in Unix box :eek: (0 Replies)
Discussion started by: raghunath_mv
0 Replies

7. Solaris

How to check Oracle odbc connectivity in solaris ?

Hi, I have my application and database servers running on solaris. I need to check Db connectivity for a datasource in my Db server. Please guide me how to do it in solaris env. Aru (2 Replies)
Discussion started by: aarora_98
2 Replies

8. UNIX for Advanced & Expert Users

Aix 5.3 L Odbc

Dose anybody knows about Installation and setup of ODBC under AIX 5.3 L (0 Replies)
Discussion started by: uhdesai
0 Replies

9. UNIX for Advanced & Expert Users

Oracle Odbc

Hello all, i like to install an application program that will interact with the oracle database. oracle has been installed in /export/home/oracle does the new application has to be in the same directory and if not which one do you recommend? There is a drive like the ODBC in oracle to... (2 Replies)
Discussion started by: rsh
2 Replies
Login or Register to Ask a Question

Featured Tech Videos