[cx-oracle-users] Re: Inserting on table where is CLOB column

[Jani T. <re...@lu...>]

Anthony Tuininga kirjoitti:
> On 5/17/05, Jani Tiainen <re...@lu...> wrote:
> 
>>>BTW, if you __really__ have no control, you can always subclass
>>>Connection and Cursor and do whatever you need to do. Subclassing has
>>>been quite convenient and I use it myself for a number of situations
>>>where the code is used by multiple database adapters.
>>
>>Any pointers in web (example would be nice) since I'm just becoming
>>friend of Python and I might be trying to do things wrong here...
> 
> 
> Recent e-mails to this list have had some examples. Subclassing
> cx_Oracle.Connection and cx_Oracle.Cursor are the same as sublcassing
> any other class in Python -- not very helpful if you haven't done much
> of it yourself yet, I guess. :-)

Well I have something like following:

query = "insert into foobar (id, name) values (:1, :2)"
values = {'1' : 123, '2' : 'Mr. Dumb'
cursor.setinputsizes({'2' : cx_Oracle.CLOB})
cursor.execute(query, values)

But I'm getting error:
Variable_TypeByPythonType(): unhandled data type

What I'm doing wrong..?