Re: using xmltype and jdbc insert

Hey,

if you only want to store an XML-File, use CLOB.

Olaf Raether

On 21 Apr 2003 06:24:19 -0700, scottb022563_at_hotmail.com (Scott) wrote:

>I am having trouble inserting a document into a table. What is the
>correct datatype to use for a column specfifed as xmltype? here is a
>simple exmple below. thanks for the help
>
>Scott
>
>CREATE TABLE XML_TEST Oracle 9i
>(
> DOC SYS.XMLTYPE
>)
>
>
>import org.w3c.dom.*;
>
>InputStream is=PropertiesUtils.loadResourceAsStream("HealthAutoInventoryInputTemplate.xml");
> Document doc=XMLUtils.createDocFromStream(is);
> stmt=con.prepareStatement("insert into xml_test
>values(?)");
> stmt.set????(1,doc);
Received on Mon Apr 21 2003 - 12:39:07 CDT