From: "Phil R Lawrence" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject:DBD::ODBC problem
Date sent: Sun, 25 Mar 2001 23:05:43 -0800
Phil,
> I have a query that returns '3' (the correct answer) when I paste
> the SQL into an
I have a query that returns '3' (the correct answer) when I paste
the SQL into an Access Query and run it. However, the same query
returns '0' when I run it using DBD::ODBC. Can anyone please
help me find why?
Here is the simple test script:
_
use
Without looking at your code, I'd just guess your connection information is
not set right. Here's as example of how to connect to a MySQL database on
the local machine named intra_data using the "sa" user account with a
password of "sa". Edit as necessary. After you connect, you should be able
to
Here is a simple (aka crude) example :
#!/opt/freestuff/bin/perl
use DBI ;
#
# Connect to Oracle
#
my $dbh = DBI -> connect ("dbi:Oracle:", $ENV {ORAPWD}) ;
$csr_open = $dbh -> prepare (q (
BEGIN
perl_global.fd := utl_file.fopen ('/tmp', 'a.a', 'r') ;
END ;
)) ;
$csr_open -
1) Thanks for your help :)
2) Yes, we did rebuild it. We currently suspect there's a bug with 8.1.7 in
reading CLOB's from UTF-8 databases. We're checking that out. It seems to
work fine with ASCII7 DB's. I'll post when I'm sure.
-Original Message-
From: Michael A. Chase [mailto:[EMAIL PR
Did you re-build DBD-Oracle after you installed the new Oracle? Sometimes
you can get away with sticking with the old build, but not always.
Doing something with blob_read() is on the Todo list, but it doesn't look
like much has been done with it in a long time. The OCI8 version of
DBD::Oracle
I'm running DBD1.06 on a Linux machine. All worked well as long as we used
Oracle client 8.1.5. Once we made the change to 8.17, we failed to read
CLOB's continuously. An example script with output for 8.15 and 8.1.7
follow:
#--
