CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: DBI: Re: [ms10380] update table in oracle db: Edit Log


Mar 8, 2010, 1:42 AM

Views: 8174
Re: [ms10380] update table in oracle db

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)

Edit Log:
Post edited by Nila (User) on Mar 9, 2010, 5:18 AM

Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives