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

Sponsored Content

Top Forums Shell Programming and Scripting DBD::ODBC::st fetchrow_hashref failed: [unixODBC][Oracle][ODBC]Numeric value out of r Post 302181745 by sameerstephen on Friday 4th of April 2008 12:46:51 AM

04-04-2008

Registered User

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

Last edited by sameerstephen; 04-04-2008 at 01:52 AM..

sameerstephen

View Public Profile for sameerstephen

Find all posts by sameerstephen

9 More Discussions You Might Find Interesting

1. 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. UNIX for Advanced & Expert Users

Aix 5.3 L Odbc

Dose anybody knows about Installation and setup of ODBC under AIX 5.3 L

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

4. UNIX for Dummies Questions & Answers

ODBC Version

how to find the version of ODBC and the database drivers in Unix box :eek:

5. UNIX for Dummies Questions & Answers

ODBC on UNIX

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

6. 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.2.0.1.0 and the XP is Oracle client 9i 9.2.0.1.0. When I start a listener on the server, the listener starts but I receive a message �The listener supports no services�. I...

7. AIX

ODBC on 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

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

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

LEARN ABOUT DEBIAN

jifty::dbi::handle::oracle

Jifty::DBI::Handle::Oracle(3pm) 			User Contributed Perl Documentation			   Jifty::DBI::Handle::Oracle(3pm)

NAME

	 Jifty::DBI::Handle::Oracle - An oracle specific Handle object

SYNOPSIS

DESCRIPTION

       This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.

METHODS

   connect PARAMHASH: Driver, Database, Host, User, Password
       Takes a paramhash and connects to your DBI datasource.

   database_version
       Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.

   insert
       Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

   build_dsn PARAMHASH
       Takes a bunch of parameters:

       Required: Driver, Database or Host/SID, Optional: Port and RequireSSL

       Builds a dsn suitable for an Oracle DBI connection

   blob_params column_NAME column_type
       Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type.  The current
       Oracle implementation only supports ORA_CLOB types(112).

   apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
       takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;

   distinct_query STATEMENTREF
       takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.

AUTHOR

       Jesse Vincent, jesse@fsck.com

SEE ALSO

       Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle

perl v5.14.2							    2011-04-26					   Jifty::DBI::Handle::Oracle(3pm)