Re: Named Parameters Issue - ORA-01460: unimplemented or unreasonable conversion requested (Anurag Chourasia)

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