Re: Select for Update fails

Hey Brains,

Doing a select for update on a remote table is very common. I do it all over our system........so, if you've never done that type of update before, better go back and read your 7.3 manual.

A more informative and helpful response would have been more appreciated here.

Arthur

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<407da895$0$21181$626a14ce_at_news.free.fr>...
> "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 Thu Apr 15 2004 - 13:10:00 CDT