Hello,
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.