
Nila
User

Mar 8, 2010, 1:42 AM
Post #2 of 2
(7518 views)
|
Re: [ms10380] update table in oracle db
[In reply to]
|
Can't Post
|
|
Try to check your AutoCommit property in your code.
my $dbh = DBI->connect( "dbi:Oracle:$db", $username, $passwd ) || die( $DBI::errstr . "\n" ); $dbh->{AutoCommit} = 0; AutoCommit: when set to 1, DBI issues a commit after each successful SQL statement. This is very dangerous and on by default. Setting it to 0 is a good idea. If you set it to '0' then you need to commit every successful SQL statement.
(This post was edited by Nila on Mar 9, 2010, 5:18 AM)
|