Re: Update / Insert Stored Procedure

Hello,

probably the 'best' solution depends on the rate between inserts and updates, that are necessary.

In case of inserting 'under normal circumstances' and updating just sometimes, we simply use a more straight forward
method.

Just insert the data and implement an exception handler (dup_val_on_index) which is doing an update instead... Received on Thu Mar 11 1999 - 05:47:36 CST