Does using the embedded database connection allow the user to implement the executemany function that is found in 3rd party python database drivers? I am trying to implement the following.
import cx_Oracle import uno def openDB(): oDoc = XSCRIPTCONTEXT.getDocument() db = oDoc.DataSource fConnection = db.getConnection("","") connection = cx_Oracle.connect(user='????',password='????',dsn='????') cursor = connection.cursor() stmt = fConnection.createStatement() stmt.execute('delete from EMBEDDED_TABLE2') sql = "SELECT F1, F2, F3 FROM ORACLE_TABLE2" insSql="INSERT INTO EMBEDDED_TABLE2(F1, F2, F3) VALUES (?,?,?)" cursor.execute(sql) listSize=10000 while True: result= cursor.fetchmany(listSize) if result: stmt.executemany(insSql,result) else: break cursor.close() connection.close() fConnection.close()
If not, is there a way around this? Thank you very much for your assistance.