[Sqlalchemy-tickets] Issue #4290: add setinputsizes() hook for cx_oracle (zzzeek/sqlalchemy)

[Michael B. <iss...@bi...>]

New issue 4290: add setinputsizes() hook for cx_oracle
https://bitbucket.org/zzzeek/sqlalchemy/issues/4290/add-setinputsizes-hook-for-cx_oracle

Michael Bayer:

apparently we cannot generalize the setinputsizes() decision for cx_Oracle datatypes.  

after many issues reported (by me):

https://github.com/oracle/python-cx_Oracle/issues/68

https://github.com/oracle/python-cx_Oracle/issues/75

https://github.com/oracle/python-cx_Oracle/issues/181

https://github.com/oracle/python-cx_Oracle/issues/189

as of issue 189 above it's clear that there are just some cases where we can't even make an accurate decision, not to mention as cx_Oracle, the Oracle version in use, and settings like charset and numeric settings change, whether or not and how to use setinputsizes with cx_oracle is something that needs constant adjustment.

To suit cases especially like performance-altering behaviors that are touched upon in issues like #4242 as well as https://github.com/oracle/python-cx_Oracle/issues/189, we need to open this up with a new event that intercepts the dialect-level setinputsizes call.