search

jangbagu / pypyodbc

Automatically exported from code.google.com/p/pypyodbc
0 stars 0 forks source link

SQLNumParams return 0 after _free_stmt(SQL_RESET_PARAMS) #65

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
python 3.4.2 x64
win8 x64
pypyodbc 1.3.3
oracle db 11gr2
connection via DBQ string

Basiclly, I have the issue the same as this 
https://community.oracle.com/thread/2168897

I execute the query with executemany. The first row in params_list can be 
execute, but the following row with type change(mostly, it change between value 
and none) will raise error...The SQL contains 0 parameter markers...

Now, my workaround is add prepare method after line 1463. It looks like this...
    self._free_stmt(SQL_RESET_PARAMS)
    self.prepare(query_string)
    self._BindParams(param_types)

Original issue reported on code.google.com by jingfu....@gmail.com on 28 Apr 2015 at 12:56