Re: Select for Update fails

"Arthur" <amerar_at_iwc.net> a écrit dans le message de news:8b622eae.0404141101.6441e954_at_posting.google.com...
> Hey Everyone,
>
> Is this an Oracle bug?
>
> Here is my cursor statement:
>
> CURSOR tax_portal_cursor IS
> SELECT * FROM web_payment_at_remotedb WHERE caps_code IN (
> SELECT * FROM TABLE(CAST(l_caps_codes AS myTableType)) ) AND
> processed_datetime IS NULL
> FOR UPDATE OF processed_datetime;
>
> I later fill the object using this statement:
>
> SELECT CAST(MULTISET(SELECT DISTINCT(tax_cde) FROM
> iris_acct_charge_at_remotedb) as myTableType)
> INTO l_caps_codes
> FROM dual;
>
> I then try to update the record with this statement:
>
> UPDATE web_payment_at_remotedb
> SET processed_datetime = SYSDATE
> WHERE CURRENT OF tax_portal_cursor;
>
> I receive the following error:
>
> ERROR at line 1:
> ORA-02015: cannot select FOR UPDATE from remote table
>
>
> Any ideas here? Select for Update is a pretty common function. Is it
> because of the object type???
>
> Thanks,
>
> Arthur

As the message says, it is because it's a remote table.

Regards
Michel Cadot Received on Wed Apr 14 2004 - 16:09:02 CDT