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.
>
