Re: Select for Update fails

"Arthur" <amerar_at_iwc.net> a écrit dans le message de news:8b622eae.0404151010.ecca1de_at_posting.google.com...
> 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

Did you try your statement locally?

Regards
Michel Cadot Received on Thu Apr 15 2004 - 15:45:24 CDT