[cx-oracle-users] Custom Objects or VARRAYs in executemany()

[Richard A. <ric...@gm...>]

Hi all,


Just curious if there are plans for the ability to create custom objects, like SDO_GEOMETRY polygons, so that I could take advantage of executemany() for inserting large #s of polygons.  Working with points isn’t an issue since you can bind the latitude and longitude variables for SDO_POINTs, but polygons and lines are a different story.  I’ve had to loop through my list of lists, recreate the SQL statement for each insert in order to “attach” the vertices into the statement, then execute the INSERT statements one by one.  It’s not that much of a performance hit when you’re dealing with a few hundred polygons, but when you get into the hundreds of thousands, things start to slow down!


I’d love to be able to either create the SDO_GEOM for each entry in the list and use executemany(), or somehow bind a varray of the vertices to the executemany().  Unless I’ve missed something in the documentation (which is totally possible), I don’t think that’s supported yet in cx_Oracle, correct?  If not, any plans on including that in a future release?


Thanks!
Richard


—
Sent from Mailbox