>select 5 as a, 6 as b from dual union select 5 as a, 7 as b from dual;
>Two rows returned.
Indeed, two rows are returned from the database, and DBI throws away
one of them when you use selectall_hashref() giving 'a' as the key
field. Try the example program I posted.
This is not a bug in DBI, it's just not documented what exactly it's
meant to do.
RE: fetchrow_array performance ... I agree - set RasieError.... it is impossible to tell what is going on in the database without a 10046 trace. ... You aren't error checking your dbi statements - do you have RaiseError ... sender of the delivery error by replying to this message, or notify us by ... (perl.dbi.users)
Re: Evaluated "require $database" not found. ...DBI Error 1046: No database selected ... What I have found is that if the spaceare removed as per the correct syntax, then the DBI_errorhandler will trap and report a connection failure if a non-existent database is specified, as per this example: ... This requires that you first have an installation of mysql setup on a host ... (perl.dbi.users)
Re: Cant call method "prepare" on an undefined value ... Somehow you managed to have an undefined value instead of a DBI database handle in front of ->prepare, which is burried deep inside Oraperl.pm. ...Oracle HTTP Server at Server B. Both server are Solaris server. ... I have installed DBI and DBD into Server B and setup the oraperl in my perl script.... (perl.dbi.users)
RE: fetchrow_array performance ... takes a few seconds to return the rows that makes your selection... Not sure how big your database is but for anything other than ... This will create a trace file in the ... You aren't error checking your dbi statements - do you have RaiseError ... (perl.dbi.users)
