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

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

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



Nila
User


Mar 8, 2010, 1:42 AM


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

Try to check your AutoCommit property in your code.


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