If this is still a problem for you please try to make a small test script
that triggers and detects the problem. Then I can reproduce and fix it.
Thanks.
Tim.
On Thu, Sep 18, 2003 at 09:21:18AM -0500, Mark S. Davis wrote:
> Thanks for the quick response. It appears that DBI 1.38 does handle the 'no
> error text' condition. But it simply notes the missing error text as
> follows:
>
> DBI connect('pr','mark',...) failed: (no error string) at testoracle line 8
>
> But I need to find why the error text is being misplaced. The message should
> be the following (and is, in fact, when run in the debugger):
>
> DBI connect('pr','mark',...) failed: ORA-01017: invalid username/password;
> logon denied (DBD ERROR: OCISessionBegin) at testoracle line 8
>
> Since I can't use the debugger to witness the problem, I'm at a loss as to
> how to proceed. The error text is available, but prior to returning it to
> the DBI it seems to get lost. This is likely an installation issue on my
> part. But no install errors were noted. I don't think it's related to our
> Oracle installation.
>
> I had hoped that someone else might have stumbled onto this before hand.
>
> Any further help available?
>
> Thanks
> Mark Davis
>
> > -----Original Message-----
> > From: Tim Bunce [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, September 17, 2003 2:16 PM
> > To: Mark S. Davis
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: No Error Message
> >
> >
> > On Wed, Sep 17, 2003 at 12:25:12PM -0500, Mark S. Davis wrote:
> > > Though this problem has been noted by someone else in June
> > (subj: No error
> > > string and unitialized value in concatenation ), I never saw a solution.
> > > Some might suggest that I use the debugger to chase
> > > down the problem. But when I use the debugger, there is no problem!
> > >
> > > The following error is generated after using new installations of either
> > > Perl 5.6.1 or 5.8 with DBI 1.37 and DBD::Oracle 1.14 on Solaris 8.
> > > Basically, no error text is returned (note text missing after
> > 'failed: ').
> > > The trace output that follows shows that the error text is
> > retrieved, but
> > > something goes haywire. Since this problem doesn't occur when using the
> > > debugger (which is puzzling enough), I'm not sure how to pursue this.
> > >
> > > ----------------
> > > Use of uninitialized value in concatenation (.) or string at
> > > /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBI.pm line 584.
> > > DBI connect('pr','mark',...) failed: at testoracle line 7
> > > Can't call method "prepare" on an undefined value at testoracle line 11.
> > > ----------------
> >
> > I believe this is fixed in DBI 1.38 on CPAN now.
> >
> > Tim.
> >
>
