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

[Anurag C. <anu...@gm...>]

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
<gt...@gt...>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
>