Re: [cx-oracle-users] cx_Oracle 5.2

[William W. L. K. <wil...@gm...>]

I have managed to reproduce that accidentally while working on one of my
projects.

[root@POC-DB]# python
Python 2.6.6 (r266:84292, Apr 11 2011, 15:50:32)
[GCC 4.4.4 20100726 (Red Hat 4.4.4-13)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
>>> connection = cx_Oracle.connect("oracle/oracle@poc-db")
>>> cursor = connection.cursor()
...
...
...
>>> cursor.execute(str(my_query1))
<cx_Oracle.Cursor on <cx_Oracle.Connection to oracle@poc-db>>
>>> cnum_check1 = cursor.fetchall()[0][0]
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
IndexError: list index out of range
>>>


Please advise.
Will

On Thu, Jul 23, 2015 at 9:13 AM, Mike Bayer <mi...@zz...>
wrote:

>
>
> On 6/20/15 11:40 PM, Anthony Tuininga wrote:
>
>  What is cx_Oracle?
> cx_Oracle is a Python extension module that enables access to Oracle for Python 2.x and 3.x and conforms to the Python database API 2.0 specifications with a number of enhancements.
>
>
> Where do I get it?
> http://cx-oracle.sourceforge.net
>
>
>
>  What's new?
>
>  http://cx-oracle.readthedocs.org/en/latest/releasenotes.html
>
>
> One of my users is seeing issues with SQL result sets returning zero rows
> when upgrading to cx_Oracle 5.2 from 5.1.3.   Unfortunately we don't have a
> simple reproduction case, and it also involves SQLAlchemy which I know
> rules out it being a simple test case for cx_Oracle developers.   However,
> I'm hoping that some other cx_Oracle users eventually can confirm some
> similar issue to shed some light on it, so consider this post to be at
> least a flag that something has changed for at least one user:
>
>
> https://bitbucket.org/zzzeek/sqlalchemy/issues/3491/queryfirst-sometimes-returns-none
>
>
>
>
>
> ------------------------------------------------------------------------------
>
>
>
> _______________________________________________
> cx-oracle-users mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>