[cx-oracle-users] Issue with fetchraw and executemanyprepared on 4.2.0

[Chris D. <cdu...@ya...>]

Anthony,

Here's the test case (surfaced as Oracle primary key errors) for issues with fetchraw /
executmanyprepared in 4.2.0 (Oracle 9.2.0.7 on Linux)

Table setup

create table input (col1 char(3), col2 char(2));
insert into input values ('xxx', 'xx');
insert into input values ('yyy', 'yy');
create table output (col1 char(3), col2 char(2));

Python code

import cx_Oracle as cx
db1 = cx.connect("u1/p1@db1")
c1 = db1.cursor()
c2 = db1.cursor()
c1.arraysize = 5
c2.arraysize = 5
sourceVars = c1.execute("select col1,col2 from input")
targetVars = c2.setinputsizes(*sourceVars)
c2.prepare("insert into output (col1,col2) values(:arg1, :arg2)")
rowsFetched = c1.fetchraw()
print str(rowsFetched)
c2.executemanyprepared(rowsFetched)
db1.commit()

Fails with:

Traceback (most recent call last):
  File "selIns.py", line 13, in ?
    c2.executemanyprepared(rowsFetched)
cx_Oracle.InterfaceError: iterations exceed bind array size

in 4.2.0 but works fine with 4.1.2

Hope this helps.

Chris


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com