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

Discussion in 'Python' started by Ian Kelly, Jan 4, 2011.

  1. Ian Kelly

    Ian Kelly Guest

    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
    Ian Kelly, Jan 4, 2011
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Benson, John
    Replies:
    1
    Views:
    2,216
    Aurelio Martin
    Jan 28, 2004
  2. Pieter Claerhout
    Replies:
    0
    Views:
    600
    Pieter Claerhout
    Jan 28, 2004
  3. Damjan

    a cx_Oracle ORA-01036 problem

    Damjan, May 5, 2005, in forum: Python
    Replies:
    4
    Views:
    2,411
    Damjan
    May 12, 2005
  4. Mauricio Martinez Garcia
    Replies:
    0
    Views:
    651
    Mauricio Martinez Garcia
    Jan 4, 2011
  5. CJM
    Replies:
    4
    Views:
    461
Loading...

Share This Page