Most likely, it's that you are not committing the transaction.<br><br><div><span class="gmail_quote">On 2/1/06, <b class="gmail_sendername">python eager</b> <<a href="mailto:python_eager@yahoo.com">python_eager@yahoo.com
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div> <div> <div>Hi, This my code snippet.</div> <div>I am deleting records. But the sql statment working fine. but it will not delete. i have two files. one is db_connection, and other one is PerDetailsDAO.
</div> <div> </div> <div>i am creating object in PerDetailsDAO for db_connection.py</div> <div>Thereafter executing the sql statement.</div> <div>But the particular record will not deleted.</div> <div>What is the error?
</div> <div>Please rectify the problem</div> <div>Thank you</div> <div> </div> <div> </div> <div><strong><u>File Name : db_connection.py</u></strong></div> <div><strong></strong> </div> <div>import cx_Oracle<br>class db_connection:
</div> <div> def getConnection(self):<br> dbconnection = cx_Oracle.connect("username", "password", "hoststring")<br> cursor =
dbconnection.cursor()<br> cursor.arraysize = 50<br> return cursor </div> <div> </div> <div> <div><strong><u>File Name : PerDetailsDAO.py</u></strong></div> <div><strong><u></u></strong> </div></div> <div>
class PerDetailsDAO:</div> <div> def delete(self,pid):<br> con = db_connection()<br> cursor = con.getConnection()<br> sql = "DELETE FROM PERSONALDETAILS WHERE PID =100"<br> cursor.execute
(sql)<br></div> <div>regards</div><span class="sg"> <div>Python Eager</div></span><span class="ad"> <div> </div></span></div></div><span class="ad"><p>
</p><hr size="1">Do you Yahoo!?<br>
With a free 1 GB, there's more in store with <a href="http://us.rd.yahoo.com/mail_us/taglines/mailstorage/*http://mail.yahoo.com/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Yahoo! Mail.</a>
<p></p></span><br>_______________________________________________<br>DB-SIG maillist - <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:DB-SIG@python.org">DB-SIG@python.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://mail.python.org/mailman/listinfo/db-sig" target="_blank">
http://mail.python.org/mailman/listinfo/db-sig</a><br><br><br></blockquote></div><br><br clear="all"><br>-- <br>Nervous passengers are advised to wear a blindfold.