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