SPUG: DBI: column gets added despite autocommit off and no commit

Adrian Hands AEH at akc.org
Mon Jun 26 18:15:18 PDT 2006


column or row?

adding a column is a DDL change, and NOT part of any transaction.

inserting a row IS a DML change, and IS transactional.
You will "see" the row before the commit, but other sessions (i.e. db connections) should not.


-----Original Message-----
From: spug-list-bounces+aeh=akc.org at pm.org on behalf of Satish Gupta
Sent: Mon 6/26/2006 7:47 PM
To: spug-list at pm.org
Subject: SPUG: DBI: column gets added despite autocommit off and no commit
 
I have script, using DBI,  to alter a table to add/modify column in an Oracle table. I have set autocommit off and didn't invoke commit(). In fact, I invoked rollback(). So I was surprised to see that I was able to add a column to the table!
   
  Should this be so? What else could be causing this behavior?
   
  Thanks
   

 		
---------------------------------
Yahoo! Sports Fantasy Football '06 - Go with the leader. Start your league today! 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.pm.org/pipermail/spug-list/attachments/20060626/55650957/attachment.html 


More information about the spug-list mailing list