Re: [cx-oracle-users] setinputsizes problem?

[Amaury F. d'A. <ama...@gm...>]

2010/7/4 Jason Boorn <jb...@gm...>:
> now I get the following:
>
>
> ORA-01036: illegal variable name/number
>
> I tried defining the input by both position (:1) and by named argument
> (:value1)
>
> By position,
> My SQL expression reads : INSERT INTO . . . values (:1, null . . .)
> And my execution is (cursor.execute(sql, *clobs))

Here it's the other way round :-)
The documentation of cursor.execute:
http://cx-oracle.sourceforge.net/html/cursor.html#Cursor.execute
states that the parameters must be given as one sequence.
Try with
   cursor.execute(sql, *clobs)


-- 
Amaury Forgeot d'Arc