Re: Silencing DBI "(err=0, errstr=undef, state=undef)" errors DBD::Oracle



On Thu, Dec 22, 2005 at 10:31:57AM +0100, David Landgren wrote:
> List,
>
> I have an $application that uses Oracle on Windows 2000, and I speak to
> the database with ActiveState Perl 5.6, since 5.6 is the last version
> for which Oracle allows AS to package DBD::Oracle. This reason, as much
> as anything else, precludes me from upgrading to 5.8. Yes, I have a
> valid license (although we are talking about 8.1.7 here). I don't fancy
> compiling a perl myself for this box.

I believe ActiveState are now shipping a pre-built DBD::Oracle
with an installer that will automatically download Oracle Instant Client.
(Say yes when prompted, even if you have IC installed already.)

> Everything is now working correctly, except that I am getting the
> following non-error warnings:
>
> DBD::Oracle::db selectall_arrayref warning: (err=0, errstr=undef,
> state=undef) at foo.pl line 666.

That was fixed in 1.16. The Changes file says:

Fixed setting of $DBI::err to 0 triggering PrintWarn in DBI >= 1.41.

Tim.

.



Relevant Pages

  • Oracles 10gR2 Automated Storage Management implementation on CentOS 4.1 (RHEL AS 4 U1)
    ... Actually there are several nice articles on Oracle Technical Network ... the first Installer run supposed to build it. ... with the disk's group for database supposed to be built during the ... you install the optional add-on Automatic Storage Management support ...
    (comp.databases.oracle.server)
  • Re: Installation problem Oracle 10g on FC3 - TOra
    ... database name without dot but the default value has dot ... Oracle is working, ... unable to connect to the database. ... The installer gives me an error during the installation of ...
    (Fedora)
  • Installing Oracle10g (10.2.0.1) on CentOS 4.1 (RHEL AS 4 U1)
    ... there are several nice articles on Oracle Technical ... Instance creating during the first Installer run supposed to build ... the optional add-on Automatic Storage Management support library, ... database, and to exploit the capabilities and strengths of storage ...
    (comp.databases.oracle.server)
  • Re: Installation problem Oracle 10g on FC3 - TOra
    ... database name without dot but the default value has dot ... Oracle is working, ... unable to connect to the database. ... > The installer gives me an error during the installation of ...
    (Fedora)
  • Silencing DBI "(err=0, errstr=undef, state=undef)" errors
    ... I have an $application that uses Oracle on Windows 2000, and I speak to the database with ActiveState Perl 5.6, since 5.6 is the last version for which Oracle allows AS to package DBD::Oracle. ... I have tried setting all sorts of incantations in the creation of database handles, such as setting RaiseError and PrintError to zero. ... I had high hope for the HandleError and HandleSetErr attributes. ...
    (perl.dbi.users)