Have you looked at the DBI documentation for $dbh->commit and $dbh->rollback? You have to make sure AutoCommit is off, but this too is explained in the documentation for these functions. I found "perldoc DBI" to be sufficient for anything I needed to do.
-dpf- ----------------------- David P. Fannin Database Administrator [EMAIL PROTECTED] UM-Rolla Computing and Information Services FAX (573) 341-4216 URL http://www.umr.edu/~dpf PHONE (573) 341-4841 ----------------------- -----Original Message----- From: Michael Grau [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 3:10 PM To: [EMAIL PROTECTED] Subject: Inserts in multiple tables I saw an example of the following, but I now cannot find it anywhere ... Can some one share or point me to an example where data is inserted into two or more (Oracle) tables, but none of the changes are committed unless the inserts to _all_ of the tables were successful? TIA
