I am trying to use multi-threading in my code for faster performance. I get a result set using a stored procedure as follows -
OPEN p_eft_noc FOR
from NOTICE_OF_CHANGE eftnoc
where nvl(eftnoc.process_date, 'N') <> 'Y'
order by MEMBERSHIP_NUMBER;
This result set can return any number of rows from 0 to 3000. I am using java code and once I obtain the result set, i need to divide it into 8 parts so that each part is processed separately in a thread.
Can someone help me, i need to figure out how to divide this result set...and should i do it in stored procedure itself or in java code and how. Thanks...