[cx-oracle-users] insert a well known binary object (WKB)

[John C. - N. F. <joh...@no...>]

Hello All,

I have a WKB that I'm trying to insert into a SDO_GEOMETRY column.
Something like this:

cursor.execute("""
    insert into SURVEY(OBJECTID,SURVEY,SHAPE)
    values (:objectid, :survey, SDO_UTIL.FROM_WKBGEOMETRY(:wkb))""",
    objectid=objectid, survey='H13195', wkb=wkb
)

However, I keep getting the error:

cx_Oracle.DatabaseError: ORA-01461: can bind a LONG value only for insert
into a LONG column


Can someone please point me in the right direction?

Thanks!

--john