Re: Oracle Ingres Gateway

"Geb Kos" <gko_at_tauw.nl> wrote in message news:EJ9J7.8426$G75.1666818_at_zwoll1.home.nl...
> Is there anyone who has experience with the oracle product "Oracle Ingres
> Gateway"?
>
> We are running in some difficulties and therefore making almost no
progress.
>
> Our problem we have now is working with the oracle "select for update",
> example:
>
> 18:02:04 oracle_at_tic51 ~ % cat test.sql
> SELECT "kostenplaatscd",
> "kostenplaatsoms"
> FROM "kostenplaats"_at_tg4ingr
> FOR UPDATE OF "kostenplaatscd";
>
>
>
> 18:02:08 oracle_at_tic51 ~ % sqlplus -s user/passwd @test
> SELECT "kostenplaatscd",
> *
> ERROR at line 1:
> ORA-02070: database TG4INGR does not support select for update in this
> context
>
>
> Is there a way to work around this?
>
>
> Any help is welcome, thanks in advance, Geb Kos, gko_at_tauw.nl
>
>

Maybe just issue
lock table kostenplaats in row share mode; before the actual update.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address