cx-oracle-users

[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

Re: [cx-oracle-users] ORA-01036

[Anthony T. <ant...@gm...>]

Hi,

My only thoughts are that you are using that cursor for some other
queries besides the one shown here? Do you have threads running in
this application and you forgot to turn on threaded mode? Besides
those possibilities I can't think of anything else -- and the only
time I run into that exception is when my sql and my bind variables
don't match for some reason. It would be nice if Oracle told you
__which__ bind variable it didn't like as that would aid in debugging
the problem but unfortunately it does not. :-( Good luck!

Anthony

On Wed, Jul 28, 2010 at 4:08 AM, rwe <rog...@to...> wrote:
> 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
>
>
> ------------------------------------------------------------------------------
> The Palm PDK Hot Apps Program offers developers who use the
> Plug-In Development Kit to bring their C/C++ apps to Palm for a share
> of $1 Million in cash or HP Products. Visit us here for more details:
> http://ad.doubleclick.net/clk;226879339;13503038;l?
> http://clk.atdmt.com/CRS/go/247765532/direct/01/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>