d.com]
Sent: Friday, May 15, 2015 10:13 AM
To: Kyle A. Hamilton; 'dbi-users@perl.org'
Subject: Re: dbi selectall_hashref drops results
On 15/05/15 15:56, Kyle A. Hamilton wrote:
> I ran into an issue where dbi’s selectall_hashref will drop results
> returned from the database. If
through the
results, I get the same data as I get from manually querying the database. I
can provide the proprietary code as an example, just want to make sure this is
the correct place to submit this.
Kyle A. Hamilton | OSS Administrator
Office: 515-830-0577
[http://insfamilyofcompanies.com
Thanks to all who replied. Your quick suggestions got me in the right
place to solve the problem.
-Kyle
> Hello!
>
> If you use fetchrow_hashref(), you'll end up with a hash that has the column
> names as the keys. To get get the column names from a record, simply
> retr
ns by the
appropriate column name.
Here is a sample of what I'm trying to do (3 requests to the same sub):
@ArrayOfHashes = sub_get_sql('SELECT * FROM table WHERE trxnum = 100;');
@ArrayOfHashes = sub_get_sql("SELECT trxdate FROM table WHERE trxowner =
\'kyle\';"
d the ORA-12154 errors.
We were running Perl 5.6.0, DBI 1.14, Apache::DBI 0.88, DBD::Oracle 1.06,
and the Oracle 8.06 client against an 8.0.6.3.0 db.
Make sure you let me know if you figure it out ;-)
- Kyle
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROT