Error python + cx_Oracle :Oracle-Error-Message: ORA-01036: illegal variable name/number

[Ian Kelly]

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