1. Inserting a Clob type of Clob Type Data Direct INSERT can be inserted because of the characters, so you have to insert in the form of objects. Example: First, create a table with a Clob field: Create Table Test (ID Integer, Content Clob) ;
Then insert a null value
String strsql = "INSERT INTO TEST (ID, Content) VALUES ('0001' ,?)";
Con.SetAutocommit (false); // conn is the Connection object
// Create and instantiate a CLOB object
Clob Clob = New Clob (ORACLECONNECTION) Con);
Clob = Oracle.Sql.Clob.createTemporary (ORACLECONNECTION) CON, TRUE, 1);
/ / Assign a value for the CLOB object
Clob.putString (1, Formatesinglequotes);
OracleConnection Ocon = (ORACLECONNECTION) CON;
OraclePreparedStatement PSTMT = (ORACLEPREPAREDStatement) Ocon.prepareCall (strsql);
PSTMT.SETCLOB (1, Clob);
INT i = pstmt.executeUpdate ();
PSTMT.Close ();
Ocon.commit ();
Ocon = NULL;
CON = NULL;
Boolean flag = true;
IF (i <= 0)
{
Flag = false;
}
IF (Flag == True)
{
