Exception when using Merge in PL/SQL

If I put the merger in a procedure, how does exception of PL/SQL apply to the merge ? Is there any special system exception for merge? Because

   merge include both insert and update, many knowledged users just stated that the exceptions of both process will apply.

Currently our design is to drop the old table and rename the staging table to theold table then process from there after load the file from a flat file. It is quick according to our senior developer, but I suspect there is a fall-out, And I want to use the new MERGE to replace the process. How do I strengthen my arguments with him? Thanks.

Chisoon Received on Wed Mar 02 2005 - 20:46:52 CST