[cx-oracle-users] ORA-01036

[rwe <rog...@to...>]

Hi,
I seem to be getting an ORA-01036 very occasionaly in some python code 
using cx_Oracle:

    def updateJobState(self, job_id, job_state, job_pid):
        try:
            sql = """update jobs set job_state=:job_state, 
job_pid=:job_pid where job_id=:job_id"""
            self.cursor.execute(sql, job_id=job_id, job_state=job_state, 
job_pid=job_pid)
            self.commit()
        except Exception:
            self.reportException()

I get the following error:

        DatabaseError: ORA-01036: illegal variable name/number

As only the variable values change, I am at a loss as to where to look.

I have the feeling it is when the database is very busy, although I 
could be wrong...

Any ideas ?? 

Thanks in advance..

Roger