Home » Developer & Programmer » JDeveloper, Java & XML » ORA-01729: for XMLType
ORA-01729: for XMLType [message #91954] Sat, 06 December 2003 07:00
rabbit
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());
pstmt_clob.execute();

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 {
Class.forName("oracle.jdbc.OracleDriver");
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

rabbit
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