Good morning.
I'm having an issue with attempting to specify the AutoCommit option on a
Connect to any Oracle database. Here is an example of my Connect
statement:
<begin>
$dbh = DBI->connect('dbi:Oracle:dbName', 'uid', 'pwd', (AutoCommit => 0))
or die "ERROR\nCouldn't connect to ORACLE database: " . DBI->errstr;
<end>
When I try to run the script, I get the following error:
<begin>
Connecting to ORACLE...install_driver(AutoCommit) failed: Can't locate
DBD/AutoCommit.pm in @INC (@INC contains: D:/Perl/lib D:/Perl/site/lib .)
at (eval 1) line 3.
Perhaps the DBD::AutoCommit perl module hasn't been fully installed, or
perhaps the capitalisation of 'AutoCommit' isn't right.
Available drivers: CSV, DB2, ExampleP, Excel, File, ODBC, Oracle, Proxy.
<end>
I am using ActiveState Perl v5.6.1.
Here is a listing of the DBD modules I have installed, with their
respective versions:
<begin>
DBD-CSV [0.2002] DBI driver for CSV files
DBD-DB2 [0.75 ] Perl driver for IBM DB2 Universal Database
DBD-Excel [0.05 ] A class for DBI drivers that act on Excel File.
DBD-ODBC [0.28 ] ODBC driver for the DBI module.
DBD-Oracle [1.12 ] Oracle database driver for the DBI module
DBD-Oracle8 [1.06 ] Oracle 8 database driver for the DBI module
DBI [1.32 ] Database independent interface for Perl
<end>
I never got an error while installing the DBI and DBD modules, so I'm at a
loss as to why the AutoCommit.pm file is missing. Have you experienced
this issue before, and would you know what the solution might be? Do I
need to go to CPAN to get the DBI module, instead of installing it using
the Perl Package Manager provided by ActiveState?
Any help you could provide would be greatly appreciated.
Regards,
Jim
Email: [EMAIL PROTECTED]
