Re: additional condition of update in merge

cschang wrote:

> I tried to learn the merge, so i tried this in a procedure however, it
> gave me an error
> MERGE INTO ORDER_STATUS_NOTIFICATION o1
> USING ( SELECT COUNT(*) v_count
> FROM ORDER_STATUS_NOTIFICATION
> WHERE CHECKOUT_TXN_ID = strCheckoutTxnID ) o2
> ON ( o2.v_count > 0)
> WHEN MATCHED THEN
> UPDATE
> SET
> EVENT_TYPE = 'FAILED',
> DATE_OF_EVENT = SYSDATE
>
> WHERE EVENT_TYPE <> 'FAILED' <-- Err: ORA-00905, Missing Keyword
> WHEN NOT MATCHED THEN
> INSERT
> (
> CHECKOUT_TXN_ID,
> EVENT_TYPE
> )
> VALUES
> (
> strCheckoutTxnID,
> 'FAILED'
> );
>
> Does that mean I can not add additional where condition for the update
> section? I was running this on 9.2 version.
>
> C Chang

You need to post the actual error message since none of us have your tables so we can't try it out.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)