iframe-proxy | Sunbelt Computer Software

32 lines (23 loc) · 1.04 KB

#------------------------------------------------------------------------------

# bind_insert.py (Section 4.3)

#------------------------------------------------------------------------------

from __future__ import print_function

import cx_Oracle

con = cx_Oracle.connect("pythonhol", "welcome", "localhost/orclpdb")

cur = con.cursor()

rows = [ (1, "First" ), (2, "Second" ),

(3, "Third" ), (4, "Fourth" ),

(5, "Fifth" ), (6, "Sixth" ),

(6, "Duplicate" ),

(7, "Seventh" ) ]

cur.executemany("insert into mytab(id, data) values (:1, :2)", rows, batcherrors = True)

for error in cur.getbatcherrors():

print("Error", error.message.rstrip(), "at row offset", error.offset)

# Now query the results back

cur2 = con.cursor()

cur2.execute('select * from mytab')

res = cur2.fetchall()

print(res)

Sunbelt Computer Software