SQL Variable Substitution Question

Shengquan Liang liang at cad.gatech.edu
Wed Jun 7 16:13:18 EDT 2000


'm trying to make a query using varible in a
Python program.

say i have yyyy = 1000
and i want to 

 select * from attt
 where bbbb = yyyy



in the documentation of DC Oracle, it says that
i shoul d use 'select * from attt'
		'where bbbb = :yyyy'

to make it work.

BUT, when i tried it this way, the 
iDC oracle reponded by:

  oci.err:(1008,'ORA-1008: not all variables bound\012')


what's the problem with that?




More information about the Python-list mailing list