Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

Easysoft Data Access

Why do I get a "transaction already started" error when calling a procedure?

Article:
00994
Last Reviewed:
26th January 2024
Revision:
1

This often happens if the procedure mixes insert/update and select statements, and autocommit has been turned off. This is quite a common question from people using Perl where the script connects with autocommit turned off:

my $dbh = DBI->>connect($ENV{DBI_DSN},
                        $ENV{DBI_USER},
                        $ENV{DBI_PASS},
                        {
                            RaiseError => 1,
                            AutoCommit => 0
                            }
                        ) || die "Database connection failed: $DBI::errstr";
Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)