Re: [cx-oracle-users] Named Parameters Issue - ORA-01460: unimplemented or unreasonable conversion requested (Anurag Chourasia)

[Tamás G. <gt...@gt...>]

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