[DB-SIG] How to use Prepared Statment?

[python eager]

Hi this my code snippet. This code will not execute. And also this code raise error.

 

DatabaseError: ORA-01036: illegal variable name/number

 

What is the problem. Please give me a solution. Is there any problem is sql statment please give the correct statment, i will apply that statment.

 

 

Code Snippet :

 

def view_one(self,pid):
sql_pStmt = "SELECT FIRSTNAME,LASTNAME FROM PERSONALDETAILS   

                     WHERE PID = ?" 
cursor.execute(sql_pStmt,pid)

 

Thank you

 

regards

Python Eager

---

Relax. Yahoo! Mail virus scanning helps detect nasty viruses!

_______________________________________________
DB-SIG maillist  -  DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig