3.4 Thick Mode cannot use cur.setinputsizes(foo=oracledb.Date) anymore

[mkmoisen]

In 3.4 thick mode, we can no longer use oracledb.Date in cur.setinputsizes. This works in 3.4 thin mode, as well as 3.3 both thick and thin modes.

3.4 thick mode:

>>> cur.setinputsizes(foo=oracledb.Date)
Traceback (most recent call last):
  File "<python-input-6>", line 1, in <module>
    cur.setinputsizes(foo=oracledb.Date)
    ~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^
  File "/opt/app-root/lib/python3.14/site-packages/oracledb/cursor.py", line 515, in setinputsizes
    return self._impl.setinputsizes(self.connection, args, kwargs)
           ~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "src/oracledb/impl/base/cursor.pyx", line 688, in oracledb.base_impl.BaseCursorImpl.setinputsizes
  File "src/oracledb/impl/base/bind_var.pyx", line 103, in oracledb.base_impl.BindVar._set_by_type
  File "src/oracledb/impl/base/bind_var.pyx", line 57, in oracledb.base_impl.BindVar._create_var_from_type
  File "src/oracledb/impl/base/var.pyx", line 334, in oracledb.base_impl.BaseVarImpl._set_metadata_from_type
  File "src/oracledb/impl/base/metadata.pyx", line 379, in oracledb.base_impl.OracleMetadata.from_type
  File "/opt/app-root/lib/python3.14/site-packages/oracledb/errors.py", line 199, in _raise_err
    raise error.exc_type(error) from cause
oracledb.exceptions.ProgrammingError: DPY-2007: expected a type

>>> cur.setinputsizes(foo=oracledb.DB_TYPE_DATE)
{'foo': <oracledb.Var of type DB_TYPE_DATE with value None>}

3.4 thin mode, 3.3 thick mode, and 3.3 thin mode:

>>> cur.setinputsizes(foo=oracledb.Date)
{'foo': <oracledb.Var of type DB_TYPE_DATE with value None>}
>>> cur.setinputsizes(foo=oracledb.DB_TYPE_DATE)
{'foo': <oracledb.Var of type DB_TYPE_DATE with value None>}

Thank you

[anthony-tuininga]

This is not a bug. The DB API doesn't specify that Date, Timestamp and Binary are types. It states that they are functions which produce data of the specified type. The fact that it worked in the past is simply an artifact. :-) You should be using datetime.date, datetime.datetime and bytes directly (or their equivalent oracledb.DB_TYPE_DATE, oracledb.DB_TYPE_TIMSTAMP and oracledb.DB_TYPE_RAW). These were the intended uses and work with all versions of python-oracledb.