Select for Update fails

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 Received on Wed Apr 14 2004 - 14:01:55 CDT