[cx-oracle-users] Positional parameters, REF's, BINARY_FLOAT and BINARY_DOUBLE

[Danny R. B. <da...@as...>]

There are many reason to switch from DCOracle2 to cx_Oracle and there are a
few that keep me from switching.
The most important one is that lack of support for positional parameters.
I.e., you cannot do something like

  cursor.execute('select 4 from dual where :1 > 1', 37)

which DCOracle2 allows you to do.
A workaround is to use named parameters and replace all the occurrences of
:<n> with :p<n> in queries. Given the heavy use of positional parameters in the code I have I would like to avoid rewriting it.
So the questions are:
Is support for positional parameters planned?
How much work would be needed to support positional parameters?


Another question is about object REFerences. It would be nice if they
would be supported. DCOracle2 support for them is limited to `Segmentation
Fault'. I already had a look and I think I could add support for REF's
myself. But before I do that I would like to know whether that's appreciated
and, more importantly, needed ... is support for REF's planned? [)


Finally, what about the new BINARY_FLOAT and BINARY_DOUBLE types in 10g.
They are high on my wishlist and I can imagine it's trivial to add support
for them. Again, is this planned?

Thanks for the hard work and the prompt and polite response,

                                                   Danny R. Boxhoorn

Kapteyn Institute / OmegaCEN               e-mail: da...@as...
Postbus 800                                  tel.: +31 (0)50 3634056
9700 AV GRONINGEN                            fax.: +31 (0)50 3636100
THE NETHERLANDS                              http://www.astro.rug.nl/omegacen