True, Bart. I thought about that though just gave that as another option, I
agree that was senseless:-) Now looking through the trace file, looks like
everything is running fine, just nothing is returned?
Ilya
-----Original Message-----
From: Bart Lateur
To: [EMAIL PROTECTED]
Sent: 9/20/01 8:45 AM
Subject: Re: DBI use with DBD:Oracle module
On Thu, 20 Sep 2001 08:12:38 -0600, Sterin, Ilya wrote:
>Then put || die $DBI::errstr at the end of the connect call or call
connect
>like this...
>
>my $dbh= DBI->connect("dbi:Oracle:host=<host name>;sid=<sid>", $user,
>$password, {RaiseError => 1});
>
>Just in case the call to connect fails.
In that case it would be very safe to assume that
my $sth= $dbh->prepare($query);
would fail with a complaint from perl like:
Can't call method "prepare" on an undefined value
--
Bart.