cx_Oracle "Expecting None or a String"

Anurag Chourasia <[email protected]> Tue, 8 Sep 2015 13:50:01 -0400
Newsgroups gmane.comp.python.db.cx-oracle
Message-ID <CANFgmFB=gN7EpqYVabX75Ps+yHQCEvZs6OeRaoKX0Na-t2Qbwg@mail.gmail.com>
All,

I am on the following cx_Oracle version

>>> cx_Oracle.version
'5.0.3'

Time and again I get this error in executing a query

expecting None or a string

The query is being executed this way

cursor.execute("SELECT * FROM APP_STORE WHERE STORE=:STORE %s"
%(order_clause),{'STORE':STORE})

What could be the reason? Similar queries executed earlier in the flow work
fine but this one does not.

Appreciate some guidance on this.

Regards,
Anurag

------------------------------------------------------------------------------

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users