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

[Anthony T. <ant...@gm...>]

Glad to see you got it working. Apologies for dropping the
xmltype(:value) from the example I gave you. It was in my code that
was working, of course. :-)

On Apr 8, 2005 2:58 PM, Charl P. Botha <cp...@gm...> wrote:
> 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/
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>