Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/oracle/python-cx_Oracle/issues/193 below:

cursor.rowcount does not reset when executing the same statement a second time · Issue #193 · oracle/python-cx_Oracle · GitHub

The cursor.rowcount attribute seems to increment when running the same query multiple times, when I expected it to reset. Example:

cur = mycon.cursor()
STMT = "SELECT * FROM DUAL WHERE 1=:s"

cur.execute(STMT, [0])
_ = cur.fetchone()
print cur.rowcount

cur.execute(STMT, [1])
_ = cur.fetchone()
print cur.rowcount

cur.execute(STMT, [1])
_ = cur.fetchone()
print cur.rowcount

cur.execute(STMT, [0])
_ = cur.fetchone()
print cur.rowcount

Expected output:

Actual output:

PEP 249 suggests the rowcount should reset to zero every time execute() is called:
https://www.python.org/dev/peps/pep-0249/#rowcount

1. What is your version of Python? Is it 32-bit or 64-bit?
   Python 2.6.6, 64-bit
   Same behaviour observed on Python 2.7.12, 64-bit

2. What is your version of cx_Oracle?
   6.3

3. What is your version of the Oracle client (e.g. Instant Client)? How was it
   installed? Where is it installed?
   Installed via pip, /usr/lib64/python2.6/site-packages/cx_Oracle.so

4. What is your version of the Oracle Database?
   12.1c

5. What is your OS and version?
   RHEL6

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4