On Tue, Jan 4, 2011 at 12:57 PM, Mauricio Martinez Garcia <morfeo...@gmail.com> wrote: > > Hi, i need help with the next error: > > "ERR_PYTHON:Oracle-Error-Message: ORA-01036: illegal variable name/number", > i used the cx_Oracle module, and the error not is only Oracle Error. > > The error its for that python don't translate the query, with the variables > ":VARIABLE" when the VARIABLE is a number, this is th ecause of Oracle > error.
You can only specify bind parameters that are used in the query. The dict you are passing in has 56 key/value pairs, but your query has only 55 variables. "TELEFONO_ICC" does not appear to be used anywhere in the query. Cheers, Ian -- http://mail.python.org/mailman/listinfo/python-list
