Search code examples
pythonxmloracle-databasexmltype

Is there an Oracle wrapper for Python that supports xmltype columns?

It seems cx_Oracle doesn't.

Any other suggestion for handling xml with Oracle and Python is appreciated.

Thanks.

Solution

  • I managed to do this with cx_Oracle.

    I used the sys.xmltype.createxml() function in the statement that inserts the rows in a table with XMLTYPE fields; then I used prepare() and setinputsizes() to specify that the bind variables I used for XMLTYPE fields were of cx_Oracle.CLOB type.