merge-statement

MERGE output cursor of SP into table?

Hi, i have a Stored Procedure which returns output as a ref cursor. I would like to store the output in another table using the MERGE statement. I'm having problems however mixing all the statements together (WITH, USING, MERGE etc..). Can somebody assist? Thanks! This is the table i want the output in (STOP_TIME is left out on purpo...

How can I specify Batch commit in Oracle Merge Statement?

I am doing a bulk insert/update for millions of records using the MERGE statement in oracle. Well, the other options could be to use FORALL making use of BULKCOLLECT and then commit but this operation will be again a slowdown the performance since I need to keep loop. Committing after completion of entire merge operation will be a perfor...