i am getting xml data as a string contain morethan 4kb size i am using thin driver oracle 9i database pls provide java programme to convert String to the java.sql.clob (not oracle.sql.clob)object to insert data in DB Table
java.sql.Clob is an interface so you can't instantiate it. I would use stmt.setAsciiStream rather than trying to create a CLOB. That way you don't have to use database specific code. It will still be stored as a CLOB in the database.
Originally posted by anilellendula kumar: My client requirement is to convert it to CLOB from string data and store in DB Table,can provide me logic to create CLOB object
I think your client meant it should be stored as a CLOB in the database. How you go about that is an implementation detail.