<DIV id=RTEContent> <DIV id=RTEContent> <DIV id=RTEContent>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 id=RTEContent><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> <DIV>Python Eager</DIV> <DIV> </DIV></DIV></DIV><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/">Yahoo! Mail.</a>