<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7638.1">
<TITLE>RE: SPUG: DBI: column gets added despite autocommit off and no commit</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>column or row?<BR>
<BR>
adding a column is a DDL change, and NOT part of any transaction.<BR>
<BR>
inserting a row IS a DML change, and IS transactional.<BR>
You will "see" the row before the commit, but other sessions (i.e. db connections) should not.<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: spug-list-bounces+aeh=akc.org@pm.org on behalf of Satish Gupta<BR>
Sent: Mon 6/26/2006 7:47 PM<BR>
To: spug-list@pm.org<BR>
Subject: SPUG: DBI: column gets added despite autocommit off and no commit<BR>
<BR>
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!<BR>
<BR>
Should this be so? What else could be causing this behavior?<BR>
<BR>
Thanks<BR>
<BR>
<BR>
<BR>
---------------------------------<BR>
Yahoo! Sports Fantasy Football '06 - Go with the leader. Start your league today!<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>