import  java.sql.*;
 import  java.util.Locale;
 import  java.util.Calendar;
 import  java.text.SimpleDateFormat;

 public   class  StatementCancelTest {

   private   static   final  String USERNAME = "<username>";

   private   static   final  String PASSWORD = "<password>";

   private   static   final  String SERVER = "jdbc:oracle:thin:@<host>:1521:<SERVICE_NAME>";

   public   static   void  main(String args[])
     throws  Exception {
    Locale.setDefault(Locale.ENGLISH);
    DriverManager.registerDriver( new  oracle.jdbc.OracleDriver());
    Connection con = DriverManager.getConnection(SERVER, USERNAME, PASSWORD);
    con.setAutoCommit(false);

    PreparedStatement pst = con.prepareStatement(
      "begin\n" +
      "  loop dbms_lock.sleep(2); end loop;\n" +
      "end;"
    );

    SimpleDateFormat dateFormat =  new  SimpleDateFormat("dd.MM.yyyy hh:mm:ss");
    System.out.println(
      dateFormat.format( new  Date(Calendar.getInstance().getTimeInMillis()))
    );
    StatementThread statementThread =  new  StatementThread(pst);
    Thread.sleep( 10000 );
    pst.cancel();
    System.out.println("pst.cancel()");
    System.out.println(
      dateFormat.format( new  Date(Calendar.getInstance().getTimeInMillis()))
    );
  }
}

 class  StatementThread
   extends  Thread {

  PreparedStatement pst;

   public  StatementThread(PreparedStatement pst) { this .pst = pst;}

   public   void  run() {
     try  {
      pst.execute();
    }  catch  (SQLException e) {
      System.err.println("Error executing statement\n" + e.toString());
       throw   new  RuntimeException("Error executing statement\n" + e.toString());
    }
  }
}

//StatementThread statementThread = new StatementThread(pst);
 new  StatementThread(pst).start();

Error executing statement
java.sql.SQLException: ORA-01013: user requested cancel of current operation
ORA-06512: at "SYS.DBMS_LOCK", line 201
ORA-06512: at line 2

Exception in thread "Thread-0" java.lang.RuntimeException: Error executing statement
java.sql.SQLException: ORA-01013: user requested cancel of current operation
ORA-06512: at "SYS.DBMS_LOCK", line 201
ORA-06512: at line 2

	at StatementThread.run(StatementCancelTest.java:56)