DA Morgan wrote:
> 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.
I believed I point out the place where Oracle reveal the error and the
message with the SQLCODE. Please read carefully.
Received on Thu Mar 10 2005 - 20:52:41 CST