[DB-SIG] delete the records query

[python eager]

    Hi, This my code snippet.
  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.
   
  i am creating object in PerDetailsDAO for db_connection.py
  Thereafter executing the sql statement.
  But the particular record will not deleted.
  What is the error?
  Please rectify the problem
  Thank you
   
   
  File Name : db_connection.py
   
  import cx_Oracle
class db_connection:
     def getConnection(self):
        dbconnection = cx_Oracle.connect("username", "password", "hoststring")
        cursor = dbconnection.cursor()
        cursor.arraysize = 50
        return cursor 
   
    File Name : PerDetailsDAO.py
   

  class PerDetailsDAO:
     def delete(self,pid):
        con = db_connection()
        cursor = con.getConnection()
        sql = "DELETE FROM PERSONALDETAILS WHERE PID =100"
        cursor.execute(sql)

  regards
  Python Eager
   



		
---------------------------------
Do you Yahoo!?
 With a free 1 GB, there's more in store with Yahoo! Mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/db-sig/attachments/20060131/8465c123/attachment.html