Didn't know that SUN bought Oracle, but these days you never know,
especially when both of them are more focused on overthrowing Mico$oft than
their product:-) Kidding...
Did you explicitly set AutoCommit => 0, if not you must do that in order to
use commit().
Not sure what is overflowing and why, did you get an error message? How do
you know it's overflowing? Use trace() (see 'perldoc DBI') to get the trace
output and send to list.
Ilya Sterin
-----Original Message-----
From: jeff knot [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 6:14 PM
To: [EMAIL PROTECTED]
Subject: DBI buffer commit
Hi,
I am new to this list and I have the following question:
My database is SUN Oracle. I try to use
perl DBI to update the record:
$sth=$dbh->prepare("update mytable set filed=mynewrecord
where id=?");
$sth->execute ($i);
After doing the above over 1000 lines, my database stucks. I guess my buffer
overflow. Then
I use $dbh->commit; trying to clear the buffer, but
it is not working. I am wondering if there is a solution.
Jeff
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
