>
> I do what you originally did ($dbh->do("delete...") all the
> time on Oracle 8.1.7. The only difference I have is
>
> my $dbh = DBI->connect("dbi:Oracle:database", "user", "pass",
> { RaiseError => 1, AutoCommit => 0 });
>
> i.e. I explicitly set AutoCommit off. I always have done
> that, and don't know what the default is. It sounds like
> AutoCommit is on. 42K commits wouldn't be very pretty, but I
> would expect that some of the rows would have been deleted.
> Have you tried trace()?
Hold it. This needs to be clear...
If you have AutoCommit on and one delete statement that deletes 42,000 rows,
that's no
different than without AutoCommit and one commit after the statement.
AutoCommit would
*not* commit after each row is deleted in a single statement. It commits after
the
statement is complete.
Jeff
