Oracle Ingres Gateway

From: Geb Kos <gko_at_tauw.nl>
Date: Fri, 16 Nov 2001 15:45:53 +0100
Message-ID: <EJ9J7.8426$G75.1666818_at_zwoll1.home.nl>

[Quoted] 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.

[Quoted] 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 Received on Fri Nov 16 2001 - 15:45:53 CET