Michel Cadot wrote:
> "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
In addition to which one might ask ... why are you trying to lock the
entire table?
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Apr 15 2004 - 01:55:32 CDT
