Re: Named Parameters Issue - ORA-01460: unimplemented or unreasonable conversion requested (Anurag Chourasia)
Anurag Chourasia <[email protected]>
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CANFgmFCwrO2uqqQ3NVx4CqJ1WWkvWbD8_8EHCOQMw7SNxOfDpg@mail.gmail.com> |
Hi Tamas, Thanks for the response. Here is the result... TAG_NBR: u'2928982' <type 'unicode'> Please let me know if this gives any more ideas. I will also try a explicit type conversion using str() to see if that makes a difference. Regards, Anurag On Mon, Apr 8, 2013 at 5:32 PM, Tamás Gulácsi <[email protected]>wrote: > Az I've sent to the mailing list earlier: > > PLEASE print out the type of TAG_NBR! > print 'TAG_NBR:', repr(TAG_NBR), type(TAG_NBR) > > Because with bind variables, cx_Oracle has to decide what kind of thing is > that, and how to bind it (for strings, FIXED_CHAR, VARCHAR, NVARCHAR, CLOB > are all possible candidates). > > Maybe even an explicit conversion could help, but even then the language > (NLS_...) parameters can joke you! > T_cursor.execute("SELECT DISTINCT(TAG_STATUS) FROM TAG_HIST WHERE TAG_NBR > = :TAG_NBR", {'TAG_NBR': str(TAG_NBR)}) > > And watch out for NLS_ environment variables! > > GThomas > ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users