Re: Pain with heterogenous services (DG4ODBC)

From: joel garry <>
Date: Mon, 7 Jan 2013 13:21:17 -0800 (PST)
Message-ID: <>

On Jan 7, 9:33 am, Mladen Gogala <> wrote:
> The service is configured correctly but it cannot be used for anything
> except querying:

> I specifically committed after the bulk collect into, to start a new
> transaction and to make sure that the transaction is not distributed.
> It didn't work. I know that there is a specific gateway for DB2, but I
> cannot use it because of $$$. So, ODBC gateway isn't particularly useful.
> Bummer.
> --
> Mladen Gogala
> The Oracle Whisperer

02025, 00000, "all tables in the SQL statement must be at the remote database"
// *Cause: The user's SQL statement references tables from multiple databases.
// The remote database is not Oracle V7 or above, and can perform
// updates only if it can reference all tables in the SQL statement.
// *Action:

Guess you'll have to use something newer than O6 lol

But seriously, even winblows can update with odbc, I take it you are using some unix thing?

I note from the gateway docs even it requires the use of the sqlplus copy command:

"The Oracle SQL INSERT command is not supported..."

COPY FROM scott/tiger_at_ORACLE -
INSERT scott.EMP_at_DRDA -

-- is bogus.
Received on Mon Jan 07 2013 - 22:21:17 CET

Original text of this message