[pypy-issue] [issue1530] cx_Oracle 5.1.x doesn't work with pypy

mic tracker at bugs.pypy.org
Tue Nov 12 12:40:51 CET 2013


mic <fanlinsheng at gmail.com> added the comment:

db/backends/oracle/base.py, Line 674
====================================
        try:
            print query
            print '-----\n'
            # print self._param_generator(params)
            return self.cursor.execute(query, self._param_generator(params))
        except Database.IntegrityError, e:
            raise utils.IntegrityError, utils.IntegrityError(*tuple(e)), 
sys.exc_info()[2]
        except Database.DatabaseError, e:
            print e

Console:
================
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT 
= 'YYYY-MM-DD HH24:MI:SS.FF' NLS_TERRITORY = 'AMERICA'
-----

positional and named binds cannot be intermixed
SELECT * FROM (SELECT ROWNUM AS "_RN", "_SUB".* FROM (SELECT 
"DJANGO_SESSION"."SESSION_KEY", "DJANGO_SESSION"."SESSION_DATA", 
"DJANGO_SESSION"."EXPIRE_DATE" FROM "DJANGO_SESSION") "_SUB" WHERE ROWNUM <= 21) 
WHERE "_RN" > 0
-----

positional and named binds cannot be intermixed
[12/Nov/2013 19:16:46] "GET / HTTP/1.1" 500 151201

I found: [Named Binds and Positional Binds] link:
http://docs.oracle.com/cd/B10501_01/appdev.920/a96584/oci05bnd.htm

But why bugs?

----------
nosy: +mic

________________________________________
PyPy bug tracker <tracker at bugs.pypy.org>
<https://bugs.pypy.org/issue1530>
________________________________________


More information about the pypy-issue mailing list