Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> using xmltype and jdbc insert
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 - 08:24:19 CDT
![]() |
![]() |