«

On Tue, Jan 4, 2011 at 12:57 PM, Mauricio Martinez Garcia
<> 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