Unicode / cx_Oracle problem

Richard Schulman raschulmanxx at verizon.net
Sun Sep 10 05:17:19 CEST 2006

>>  cursor.execute("""INSERT INTO mean (mean_id,mean_eng_txt)
>>      VALUES (:id,:mean)""",id=id,mean=mean)
>>  "cx_Oracle.NotSupportedError: Variable_TypeByValue(): unhandled data
>> type unicode"
>> But when I try putting a codecs.BOM_UTF16_LE in various plausible
>> places, I just end up generating different errors.

>Show us the alleged plausible places, and the different errors. 
>Otherwise it's crystal ball time again.

More usefully, let's just try to fix the code above. Here's the error
message I get:

NotSupportedError: Variable_TypeByValue(): unhandled data type unicode

Traceback (innermost last):

File "c:\pythonapps\LoadMeanToOra.py", line 1, in ?
  # LoadMeanToOra reads a UTF-16LE input file one record at a time
File "c:\pythonapps\LoadMeanToOra.py", line 23, in ?
  cursor.execute("""INSERT INTO mean (mean_id,mean_eng_txt)

What I can't figure out is whether cx_Oracle is saying it can't handle
Unicode for an Oracle nvarchar2 data type or whether it can handle the
input but that it needs to be in a specific format that I'm not

- Richard Schulman

More information about the Python-list mailing list