Greetings:

We are facing below exception, while executing a query "UPDATE TRN_WSF_SERVICE_AUDIT SET REQUEST=EMPTY_CLOB() WHERE TRN_WSF_SERVICE_AUDIT_SID = 75002202" here REQUEST is a CLOB datatype.

Detailed error
-------------------------------------------------------------------------
java.sql.SQLException: SQL string is not Query
                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1176)
                at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4767)
                at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4895)
                at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1399)

String updateStatement =
        "update MY_TABLE" +
        "set COL = COL + ? " +
        "where BLAH = ?";

    try {
        con.setAutoCommit(false);
        updateTotal = con.prepareStatement(updateStatement);

            updateTotal.setInt(1, ...);
            updateTotal.setString(2, ...);
            updateTotal.executeUpdate();
            con.commit();
        }