Re: [cx-oracle-users] DDL prepared problem

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

On Fri, Sep 3, 2010 at 8:39 PM, sky2roy sky2roy <sk...@gm...> wrote:
> cursor.execute() is simple.  and can i change the sql and replace text.

I'm not sure what you mean by changing the SQL and replacing text. You
can call cursor.execute() with different SQL each time without any
problem. If you pass the same SQL then internally less work is done
the second and any subsequent time. If that doesn't explain things,
please ask again.

> but . i just want to know why cx_oracle is not support this? or  my code has
> an error?

This is supported. I was just curious why you were doing what you were
doing since it seemed counterproductive. :-) The error is a rather
generic one that Oracle raises when the parameters do not match the
placeholders. Sometimes they can be difficult to see as Oracle doesn't
bother telling you __which__ placeholder it is having difficulty with!
If you want me to show you exactly the error you are having, send me
everything needed to replicate the code in my own environment and I'll
take a look.

> my problme is cleared.  using cursor.execute ..

Excellent. If you need further help, however, let me know.

Anthony