My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 386: oracle 11gR2 odbc driver fails on executemany
1 person starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----


 
Reported by nimar.arora@gmail.com, Nov 12, 2014
What steps will reproduce the problem?

1. Install pyodbc
2. Install oracle 11gR2 ODBC client
3. Run a simple script with execute many

conn = pyodbc.connect('Driver={Oracle in OraClient11g_home1};Dbq=ORCL;Uid=user;Pwd=passw')
conn.execute('create table t(name varchar2(10), id number)')
params = [ ('A', 1), ('B', 2) ]
cur=conn.cursor()
cur.executemany("insert into t(name, id) values (?, ?)", params)
cur.execute('select * from t').fetchall()

What is the expected output? What do you see instead?

the correct output is:
[('A', 1.0), ('B', 2.0)]

instead I see:
[('A', 1.0), ('A', None)] 

What version of the product are you using? On what operating system?

pyodbc version 3.0.7
python version 2.6.6 64bit
Windows 7 64 bit

Please provide any additional information below.



Powered by Google Project Hosting