0

I was trying to implement RETURNING BULK COLLECT INTO clause feature in vertx java. I saw many example but was not able to figure out. Didn't find PreparedStatement or registerReturnParameter kind of thing. Can you please help. My Query looks like

DECLARE 
    TYPE updatedId IS TABLE OF Table1.col2%TYPE; 
    XupdatedId updatedId;
BEGIN 
    UPDATE TABLE1 
         SET col1 = 'OK' WHERE col2 IN ('abc','def')
   RETURNING col2 
        BULK COLLECT INTO XupdatedId; 
   FOR i IN 1..XupdatedId.LAST
   LOOP
        IF i > 1 THEN
            dbms_output.put_line (XupdatedId(i));
        END IF;   
   END LOOP;
END;

I am using below vertx imports

import io.vertx.ext.sql.ResultSet;
import io.vertx.ext.sql.SQLClient;
import io.vertx.ext.sql.SQLConnection;
import io.vertx.ext.sql.UpdateResult;
Amit Sinha
  • 566
  • 7
  • 22

0 Answers0