Re: Pain with heterogenous services (DG4ODBC)

From: joel garry <joel-garry_at_home.com>
Date: Mon, 7 Jan 2013 13:21:17 -0800 (PST)
Message-ID: <6296b6aa-24b8-4d6a-8001-fb0da71e4ed1_at_gg5g2000pbc.googlegroups.com>

On Jan 7, 9:33 am, Mladen Gogala <gogala.mla..._at_gmail.com> 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 Whispererhttp://mgogala.byethost5.com

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 -
USING SELECT * FROM EMP jg

--
_at_home.com is bogus.
http://searchsap.techtarget.com/feature/Top-10-SAP-versus-Oracle-showdowns

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