[DB-SIG] How to use Prepared Statment?

python eager python_eager at yahoo.com
Fri Feb 3 07:53:51 CET 2006


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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/db-sig/attachments/20060202/6381c130/attachment.htm 


More information about the DB-SIG mailing list