Hi,
I need to write a simple program to fetch a column data which is clob (oracle 9.2)
and insert/modify it and save it back to database.
I tried to use java.sql.Clob which has a setString function but that gives me
**************************************
java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:689)
at oracle.sql.CLOB.setString(CLOB.java:1148)
Please help me with this, I need this working urgently.
I also came to know that I can get a clob as a
String and save back a String as a clob but that is not working in oracle 9.2.
I think that only works with oracle 10g
Regards