Home » Developer & Programmer » JDeveloper, Java & XML » ORA-01729: for XMLType
ORA-01729: for XMLType [message #91954] Sat, 06 December 2003 07:00
Messages: 6
Registered: October 2003
Junior Member
Hi all,
i want to insert the xml data in my table with xmltype. At first i store these xml daten in another table as clob. But i get always the error message
ORA-01729: database link name expected
during the insert the xml data in xmltype column.

For the clobtable:
PreparedStatement pstmt_clob = con.prepareStatement("INSERT INTO clobtable VALUES(?, ?)");
pstmt_clob.setInt(1, f+1);
pstmt_clob.setCharacterStream(2, new java.io.FileReader(f_ordner[[f+1]]), (int)f_ordner[[+1]].length());

For the xmltable:
Connection conn = connect();
stmt.executeUpdate("UPDATE xmltable SET xml_dok = XMLTYPE.createXML(" + conn + "," + rs.getClob(2) + ")WHERE id =" + nr);

Code for connection:
public Connection connect() throws Exception {
Connection conn = DriverManager.getConnection(
"jdbc:oracle:oci:@zeus", "zhou", "diplom");
return conn;

I don't know, what's wrong with my programm. Can you help me?

thank you very much and greeting from germany

Previous Topic: about ORACLE desencrypt and Java Encrypt function
Next Topic: unsupported feature in jdbc CallableStatement
Goto Forum:

Current Time: Sun Aug 01 22:01:40 CDT 2021