X-Received: by 10.66.80.200 with SMTP id t8mr10679916pax.1.1357593679241; Mon, 07 Jan 2013 13:21:19 -0800 (PST) MIME-Version: 1.0 Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!212.6.121.138.MISMATCH!newsfeeder.ewetel.de!border3.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!news2.euro.net!novso.com!news.he.net!news.snarked.org!newsfeed.news.ucla.edu!usenet.stanford.edu!b8no9478313pbd.0!news-out.google.com!s9ni93323pbb.0!nntp.google.com!f6no16605606pbd.1!postnews.google.com!gg5g2000pbc.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Mon, 7 Jan 2013 13:21:17 -0800 (PST) Complaints-To: groups-abuse@google.com Injection-Info: gg5g2000pbc.googlegroups.com; posting-host=64.58.150.28; posting-account=tpQovAkAAABNoH5bwsZAiff2L0zxGwdv NNTP-Posting-Host: 64.58.150.28 References: User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20100101 Firefox/17.0,gzip(gfe) Message-ID: <6296b6aa-24b8-4d6a-8001-fb0da71e4ed1@gg5g2000pbc.googlegroups.com> Subject: Re: Pain with heterogenous services (DG4ODBC) From: joel garry Injection-Date: Mon, 07 Jan 2013 21:21:19 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Lines: 43 Xref: news.cambrium.nl On Jan 7, 9:33=A0am, 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 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@ORACLE - INSERT scott.EMP@DRDA - USING SELECT * FROM EMP jg -- @home.com is bogus. http://searchsap.techtarget.com/feature/Top-10-SAP-versus-Oracle-showdowns