Re: [cx-oracle-users] cx-oracle-users Digest, Vol 58, Issue 3

[Tamás G. <gt...@gt...>]

Hi,

I've met with a not-so-funny phenomenon using Cursor.prepare (for
testing SQL statements validity): first, it  didn't work (some 4.x
version of cx_Oracle), but 5.0.1 does work. The phenomenon is the
following: ALTER statements DOES execute during the prepare call! DML
(insert, update, delete) does not, but DML (alter, at least) does.
Quite a painful side effect...

Is it a cx_Oracle bug or an Oracle feature?
(AIX 5.3, Python 2.7.1, cx_Oracle 5.0.1, Oracle DB 10g R2)

Thanks,

Tamás Gulácsi