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