[cx-oracle-users] INSERT INTO -- cx_Oracle
Brought to you by:
atuining
From: broletto <te...@br...> - 2012-04-28 21:44:04
|
Hello list, please i found someone can help me to resolve a problem between python and cx_Oracle i must insert some data inside my Oracle Express, i use python to do this. try: self.c.execute('''INSERT INTO MODELLO (title, descrizione, url, prezzo, sconto) VALUES(:1, :2, :3, :4, :5 )''', (item['title'], item['descrizione'], item['url'], item['prezzo'], item['sconto'] )) self.db.commit() except cx_Oracle.DatabaseError, exception: error, = exception print "Oracle error: ", error.message ** item are list of data when run this code i received an output error: Oracle error: ORA-01484: arrays can only be bound to PL/SQL statements thanks marco |