The Oracle documentation has a reasonably good discussion of transactions in the Concepts manual. There should be a copy available on line somewhere at your site. Ask your local DBA.
To take advantage of transactions in DBI, you need to set AutoCommit off, how to do this is described in the DBI docs (perldoc DBI) which you should read through at least once before you continue. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age. ----- Original Message ----- From: "Sandip Debnath" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 10, 2001 13:54 Subject: Newbie:oracle:transaction > > > Hi, > I wanted to know about the database transactions. I want to > execute a bunch of not-so-related database queries using > Oracle. I am presently using MySQL, but as I have never used > any transaction (of which I want to know the basics of), but > heard about that, I want to switch to Oracle. Now my question > is am I right? > If I am right in my understanding about the need of transaction > then how would I use the Oracle to execute say the following > statements together... > > ---- > "select sadd from USER where uid='aaaaaa'" > "select * from INFO where sadd='uyetywetyt'" > "update INFO ...." > "update .... some other tables etc. etc." > ---- > > I want to execute them as a bunch, if anything fails, it needs > to rollback the already executed statements. > > Please help, I am a newbie in understanding transactions. > Thanks in advance > Sandip >
