Try "{AutoCommit => 0}", instead of "(AutoCommit => 0)" in the connect call.
The options are passed to connect in a hash reference. Your options were
contained in a simple list which was flattened to:
$dbh->DBI->connect('dbi:Oracle:dbName', 'uid', 'pwd', 'AutoCommit', 0) ...
I don't know what any extra call arguments are supposed to be, but they are
not what you intended.
[EMAIL PROTECTED] wrote:
> 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]
--
James D. White ([EMAIL PROTECTED])
Department of Chemistry and Biochemistry
University of Oklahoma
620 Parrington Oval, Room 313
Norman, OK 73019-3051
Phone: (405) 325-4912, FAX: (405) 325-7762
