RE: $dbh->tables() printing error messages for Oracle under Cygwi n pe rl 5.8

From: Mark Buckle (mark.buckle_at_intechsolutions.co.uk)
Date: 10/31/03 

To: "'dbi-users@perl.org'" <dbi-users@perl.org>
Date: Fri, 31 Oct 2003 09:36:53 -0000

Michael,

Thanks for that reply. The error still occurs with DBD-Oracle-1.14, but
I'll replace the deprecated call with your suggestion.
Mark.

-----Original Message-----
From: Michael A Chase [mailto:mchase@ix.netcom.com]
Sent: 30 October 2003 23:35
To: Mark Buckle; 'dbi-users@perl.org'
Subject: Re: $dbh->tables() printing error messages for Oracle under
Cygwin pe rl 5.8

On Thu, 30 Oct 2003 16:32:49 -0000 Mark Buckle
<mark.buckle@intechsolutions.co.uk> wrote:

> This call :-
>
> $dbh->tables() ;
>
> gives rise to this error.
>
> Use of uninitialized value in string eq at
> /usr/lib/perl5/site_perl/5.8.0/cygwin-multi-64int/DBD/Oracle.pm line 327.
> Use of uninitialized value in string eq at
> /usr/lib/perl5/site_perl/5.8.0/cygwin-multi-64int/DBD/Oracle.pm line 327.
> Use of uninitialized value in string eq at
> /usr/lib/perl5/site_perl/5.8.0/cygwin-multi-64int/DBD/Oracle.pm line 327.
>
> DBI version 1.38
> DBD::Oracle version 1.12
>
> Oracle client and server version 8.1.7
> Has anyone any ideas what this could be ?

I'd first look at line 327 of DBD/Oracle.pm. A newer version of
DBD::Oracle might also be worth trying.

Calling tables() with no arguments is deprecated. Try

   @names = $dbh->tables( "%", "%", "%", "%" ); 

-- 
Mac :})
** I usually forward private questions to the appropriate mail list. **
Ask Smarter: http://www.catb.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
**************************************************************************************
This e-mail may contain information that is privileged, confidential
or otherwise protected from disclosure. It must not be used by, or
its contents copied or disclosed to, persons other than the intended
recipient. However, the contents of this e-mail may be intercepted,
monitored or recorded by Insurance Technology Solutions Limited
for the purposes of ensuring compliance with its policies and 
procedures. Any liability (in negligence or otherwise) arising from any
third party acting, or refraining from acting, on any information
contained in this e-mail is excluded.
If you have received this e-mail by mistake please notify our System
Administrators at mail.admin@intechsolutions.co.uk and delete this e-mail.
It is the responsibility of the recipient to ensure that the onward
transmission, opening or use of this message and any attachments will
not adversely affect its systems or data. Please carry out such virus and
other checks as you consider appropriate. No responsibility is accepted
by Insurance Technology Solutions Limited in this regard.
**************************************************************************************

Relevant Pages

  • Re: Query Oracle from Excel
    ... You will need the Oracle client sofware installed on the PC you're running ... What exactly is DBDataProvider and DBDataSource? ... Global prmUsername As String ... Dim adoConn As New ADODB.Connection ...
    (microsoft.public.excel.programming)
  • RE: Query Oracle from Excel
    ... Ron, thanks for your help...this is REALLY helping me!!!! ... Now, let's say that Oracle resides on the LAN/WAN somewhere, and I don't ... Global prmUsername As String ... Dim adoConn As New ADODB.Connection ...
    (microsoft.public.excel.programming)
  • Re: Storing time values via jdbc thin driver
    ... In Oracle you don't have just time anyway. ... Java knows Time and Date, ... There is a date data type which has a time ... string or character value. ...
    (comp.databases.oracle.server)
  • RE: $dbh->tables() printing error messages for Oracle under Cygwi n pe rl 5.8
    ... $dbh->tablesprinting error messages for Oracle under ... third party acting, or refraining from acting, on any information ... It is the responsibility of the recipient to ensure that the onward ...
    (perl.dbi.users)
  • Re: Re-logging into An Oracle Database
    ... I've done it in MS SQL but never in Oracle. ... My connection string seems to work, but the app seems to keep the old userid so I can't see the tables I need to see. ... What I prefer to do is use PTQs is to run updates via VBA, something like this. ... 'no error handling included here for this post, but error procs can be included to return a false for this function of the query does not execute. ...
    (comp.databases.ms-access)