oracle - Individual Record Logging While Handling Large no of records -
i having procedure assign products against existing list of orders. for rec_ord in(select order_id,order_prop1,order_prop2,<some more columns> order_master <some conditions>) loop <step-1:do processing on order_prop1,order_prop2> [log processing result] rec_prod in (select prod_id,prod_prop1,prod_prop2,<some more columns> product_master prod_prop1 = ord_prop1 , <some conditions>) loop <step-2:do processing using prod_prop2 , order_prop2> [log processing result] <decide whether assign or not> [log assignment or non-assignment reason] end loop end loop i tried below 2 methods. bulk collect:i combined step-1&2 in single query joining order_master & product_master. , using bulk-collect insert assignment. losing logging & tracking of individual record. for loop: used loop given above. taking way long. increasing execution time many times. i want processin