Webmaster Forum / Perl / DBI Library / June 2006

Tim,
In the most excellent
http://search.cpan.org/dist/DBD-Oracle/Oracle.pm#Oracle_and_Unicode
there is reference to the oracle internationalization documentation.

Hi List.
I've installed Oracle on my linux box (SuSE 10) and I've installed
DBD::Oracle.
I can run sqlplus as the oracle user however when I try and connect via

Hi, Please can someone help me, because whenever I run a perl script
that supposed to connect to a database, I get the following error
(please below in Italics). The file Oracle.sl does exist but I don't
know why the error keeps coming up.

I am getting the following error when I try INSERTing selected rows from
one database to another.
ORA-01843: not a valid month
Do I have to use to_date() and if so, has anyone done this with bind

-----Original Message-----
From: Govinda.Pfister@telekom.de [mailto:Govinda.Pfister@telekom.de]
Sent: Wednesday, June 28, 2006 5:26 AM
To: dbi-users@perl.org

I think that DBD::File at line 392 has a mistake in
DBI::SQL_TINYINT() constant name.
Attached is a patch against DBI 1.51 (and DBD::File v0.34)
that should solve this problem.

I read the POD of DBD::ODBC but there's only the commercial from
http://www.openlinksw.com mentionned, isn't there an open version
available?
I only need read access from Linux to MS-SQL.

Hi List;
I have needs to write a perl DBI script on a Linux host which will pull data from an instance of Oracle on a  second Linux host.
Can I grab an Oracle ODBC Driver and reference the driver in my DBI_>Connect call or do I have to download and install the Oracle client?
If ODBC ...

Hi all. My goal is to get a list of all field names and data types for
those fields in any given table in a mysql database. From reading the
DBI documentation, the only way I've been able to do this is by
preparing and executing a query against a table first. Then I would use

I am trying to locate the parameter values passed to a do method call in an
error handler called when the do method fails. I know about ParamValues
attribute but in this case I cannot locate a valid ParamValues array. All the
code uses a single connection handle. The code does:

Dear folks,
I have a question for you here. I just installed DBI
and Oracle DBD module. I tried a test script but got
the following errors:

I thought some people here would be interested in reviewing this:
I plan to publish a small module to generate SQL for simple keyword
searches.
The docs are here for easy HTML browsing:

Hey guys, I'm very green at DBI stuff, so maybe this is a stupid question.
But after going through the DBI man page and searching the web for a
couple hours, I can't find the answer. All I'm looking to do is to walk
the result set from a select statement more than once. Every ...

I'm having problems building DBD 1.51 on Solaris 9.  I have not found
anything in google that has helped with with this problem, aside from
that I should be using a compiler that was built on Solaris 9.
I needed a 64 bit version of Perl for an application I am working on.  I

Hello,
 I am trying to write a perl script to connect to our DB2 database and
do some basic SQL queries.  But I'm having trouble with making
everything play nice.