Intermitent DPY-2008: found object of type "MDSYS.SDO_GEOMETRY" when expecting object of type "MDSYS.SDO_GEOMETRY"

[hvnguy]

For context :
Oracledb version: 3.3.0
Python version: 3.12.7 64 bits
Oracle: 19.26
Running in thick mode with instant client 21.1

Hello,
I have a daily batch script that reads tables from an Oracle database, and import them to another database. The table has a SDO_GEOMETRY column, and no transformation is done to the object during the import process.

When inserting the data, I sometimes get the error "DPY-2008: found object of type "MDSYS.SDO_GEOMETRY" when expecting object of type "MDSYS.SDO_GEOMETRY"" which doesn't help much. The code is pretty much read -> convert to pandas dataframe for transformation -> insert.

A simplified sample of the code:

import oracledb
import pandas

oracledb.init_oracle_client()

con1 = oracledb.connect(user='', password='', dsn='')
with con1.cursor() as cursor:
  cursor.execute('SELECT * FROM table')
  columns = [col.name for col in cursor.description]
  rows = cursor.fetchmany(chunksize) # in my code, I have a generator function to fetch by batch
  df = pandas.DataFrame(rows, columns=columns)
  
# Transformation on the dataframe

con2 = oracledb.connect(user='', password='', dsn='')
with con2.cursor() as cursor:
  type_obj = con2.gettype("SDO_GEOMETRY")
  cursor.setinputsizes(geom=type_obj)
  insert_query = "INSERT INTO table (col1, col2, geom) VALUES (:col1, :col2, :geom)"
  cursor.executemany(insert_query, df.to_dict(orient='records'))
  con2.commit()

Help on determining where the issue could be would be appreciated.

[cjbj]

Start by upgrading python-oracledb to the latest version, which is currently 3.4.2.

[cjbj]

Additionally I would suggest using either 19c or 26ai Instant Client. These are LTS support releases. I believe some kinds of patches are not landing in the 21 'innovation' release. Also Oracle Database/Client 21's support will end sooner than the LTS releases.