oracle - JDBC Batch Insert with Returning Clause -
is there way values of affected rows using returning clause in java while using jdbc batch insert statement? able required values of single row affected.but not batch inserts?
code :
try { string query = "insert temp ( " + "org_node_id, org_node_category_id, org_node_name, " + "customer_id, created_by, created_date_time, " + "updated_date_time, activation_status )" + " values (seq_org_node_id.nextval, 11527, 'abcd', 9756, 1, sysdate, sysdate, 'ac')" +" returning org_node_id, org_node_name ?, ?"; con = dbutils.getoasconnection(); oraclepreparedstatement ps = (oraclepreparedstatement) con.preparestatement(query); ps.registerreturnparameter(1, types.integer); ps.registerreturnparameter(2, types.varchar); ps.execute(); resultset rs = ps.getreturnresultset(); rs.next(); system.out.println("org id : "+ rs.getint(1)); system.out.println("org name : "+ rs.getstring(2)); } grab (sqlexception e) { e.printstacktrace(); }
oracle jdbc batch-insert
No comments:
Post a Comment