Re: [cx-oracle-users] using bind variables to insert into xmltype colums

[Charl P. B. <cp...@gm...>]

On Apr 8, 2005 6:39 PM, Charl P. Botha <cp...@gm...> wrote:
> I've attached a complete and simple example that illustrates this, at
> least on my setup.  It also creates the necessary table called
> "xmltable".  It drops the old "xmltable", so be careful.  After
> changing the username/password, you have to do "import simple_ex;
> simple_ex.main()" from the python interpreter.

Changing the execute line to:
cursor.execute("insert into xmltable values (xmltype(:text_clob))",
                        text_clob = very_long_xml_text)
i.e. adding the xmltype() fixed this!

Thanks very much!

-- 
charl p. botha http://cpbotha.net/ http://visualisation.tudelft.nl/