Re: Exception when using Merge in PL/SQL

From: cschang <cschang_at_maxinter.net>
Date: Thu, 03 Mar 2005 21:39:16 -0500
Message-ID: <112fiilknp47k4d@corp.supernews.com>

Frank van Bortel wrote:

> cschang wrote:
>

>> 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

>
>
> Versions would help... If anything up-to-date, replace
> your old table with an external table - once.
> You then just change the file, and merge from there.
>
> You might want to query http://asktom.oracle.com
> for the term "upsert", and show the differences
> in execution times to your senior, and point out
> things have changed...

Sorry again to mention my system: 9.2.0.5 on windows 2000 w/ sp 4.

C Chang Received on Thu Mar 03 2005 - 20:39:16 CST