I have a stored procedure in Oracle which takes an input as a REF_CURSOR. What I am intending to to from java is pass an Array of Objects which has the 2 values in each object the stored procedure is trying to break and insert.
Till now I have not been able to find the correct datatype to send to this procedure, I have'nt even got into Custom Data Types with Oracle.
Can any one please tell me if there is a data type which would let me send multiple records to be inserted through the following stored procedure:
PROCEDURE sp_test_rvf(Param1 IN r_cursor)IS id_1 INTEGER := 0; id_2 INTEGER := 0; BEGIN LOOP FETCH Param1 INTO id_1, id_2; EXIT WHEN param1%NOTFOUND; INSERT INTO corr_batch_job(corr_batch_job_sid, corr_temp_sid) VALUES(id_1, id_2); COMMIT; END LOOP; END;