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

[Jason B. <jb...@gm...>]

I set up clobs as {}, inputsizes as {} and populate a single value in the
SQL statement:

INSERT INTO . . . VALUES (:value1, . . .)

clobs['value1'] = <some string>
inputsizes['value1']=cx.Oracle

I call:

destination_cursor.setinputsizes(inputsizes)

destination_cursor.execute(executestring, clobs)
I get an error:

Could not insert temp: Variable_TypeByPythonType(): unhandled data type

This was the original error which led me to use an array for clobs in the
first place.  Ideas?




On Sun, Jul 4, 2010 at 5:27 PM, Amaury Forgeot d'Arc <ama...@gm...>wrote:

> 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
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>