Stack Overflow
Stack Overflow

Questions tagged [heterogeneous-services]

In some database middleware libraries it is possible to connect to, and execute queries against, multiple databases in the context of a single query, with the middleware joining the relations from the different sources for consumption by a client. These are known as "heterogeneous joins".

Heterogeneous-services is an overarching category that relates to the ability of broker applications to unite and harmonize disparate systems into a single interface for transparent use by a client.

29 questions
9
votes
2 answers

Connecting Oracle to SQL Server via database link

I am trying to connect from Oracle 10G(on UNIX) to a SQL Server database (On windows). I have looked at the manual and i will admit that i am finding the documentation quite difficult to follow. There seems to be several options to use but none of…
ziggy
  • 15,677
  • 67
  • 194
  • 287
5
votes
1 answer

dbms_hs_parallel fails with error

I would like to load parallel data from oracle to oracle using dblink and dbms_hs_parallel package. In order to do it I have plsql listed below: declare lInserted number; begin dbms_hs_parallel.LOAD_TABLE('SIEBEL.S_LOY_CARD','SIEBEL',…
Alexander Tokarev
  • 1,000
  • 7
  • 16
4
votes
5 answers

Language integration

I may be the minority here, but it seems through my entire academic/professional career I've been taught varying languages. During this time, syntax and programming paradigms were the focus, but at no point were we taught about integrating systems…
John Claus
  • 598
  • 5
  • 10
3
votes
0 answers

Unable to create objects with db link; ORA - 0251: another session or branch in same transaction failed or finalized

I have a Heterogeneous Link between Oracle 11.2.0.3 and SQL Server 2008. When I attempt to create views, or procedures that reference the Heterogeneous Services views for system tables, I get 4 errors listed below: ORA-00604: error occured at…
Mackers
  • 1,039
  • 8
  • 21
3
votes
2 answers

Can't create Database Link to remote DB in Oracle-DB

We have a CRM system in our company, which uses an Oracle 11g database. It is developed by a third party vendor. We do not have access to the server which runs the CRM system. But nevertheless, we have working DBA login data available to us (SYS…
user748261
  • 151
  • 1
  • 2
  • 6
2
votes
2 answers

Using PL/SQL to invoke a java method that uses JDBC to connect to a SQL server database

I would like to be able to connect an Oracle database with a SQL server database. I am aware of DG4ODBC and HSODBC but i cant use those drivers for several reasons. I understand that it is possible to call java code from within PL/SQL as described…
ziggy
  • 15,677
  • 67
  • 194
  • 287
2
votes
0 answers

Connecting Oracle to SQL server using dg4odbc

apologies if this question has already been asked, i just couldn't find the answer to my case. I'm trying to make a connection (link) between Oracle 11g MS SQL database which are on 2 different servers. I've followed the instruction on this…
Mojatba
  • 39
  • 1
  • 5
1
vote
1 answer

What are the best practices for troubleshooting Heterogeneous ODBC connections?

I am trying to establish a heterogeneous ODBC connection from an Oracle 21c XE database to a Progress OpenEdge 11.7 database. I have installed a 32 bit ODBC driver on the Windows 2019 server where the 21c XE DB resides. I have set up an ODBC System …
Paul Stearns
  • 856
  • 9
  • 30
1
vote
1 answer

How update oracle heterogeneous services metadata?

I'm connecting from Oracle to different databases (MS Access, MySQL, ...). When opening the connection, the metadata (table and view definitions) from remote database is read by Oracle. But when updating a remote object metadata (add column on…
FerranB
  • 35,683
  • 18
  • 66
  • 85
1
vote
1 answer

Insert rows into a SQL Server table from Oracle

I have an Oracle 10G database running on a Unix environmnent and have a requirement to write a PL/SQL job that will be running on the Oracle database that will populate tables in another database which is a microsoft SQL Server database running on a…
ziggy
  • 15,677
  • 67
  • 194
  • 287
1
vote
1 answer

ORA-28500: [ODBC Driver 11 for SQL Server]: Attempt to access a column "UtilizaMetrica_DescontoComerci" {42S22,NativeErr = 207} - Column +30 character

I configure a Heterogenous Service from Oracle to access SQL Server using the ODBC Drive from Microsoft It works, but some query in specific table return the right message for example: ORA-28500: connection from ORACLE to a non-Oracle system…
AndyDaSilva52
  • 115
  • 3
  • 19
1
vote
1 answer

Create Database link to MS SQL Server on Oracle database

Please help.. I need to connect to a SQL Server database (B) from an Oracle database (A) which are both on Windows server machines. Here is what I did. System DS created on (A):- Name: ISECWM Driver: ODBC Driver 11 for SQL Server Test Results:…
Gaus
  • 59
  • 1
  • 3
  • 11
1
vote
2 answers

ORA-28562 data error truncation in oracle heterogenous?

I have created an Oracle heterogenous service to db2 using DG4ODBC. try login using isql and select using this query select *from workorder@maximo I get a result set all of the data but when I am login using sqlplus Oracle I get this error this…
muh faisal dinniy
  • 21
  • 7
1
vote
2 answers

Oracle PL/SQL, Database Link, and Heterogeneous Services Fails: ORA-02070: database MSAccessODBC64bit does not support TO_NUMBER in this context

I am using Oracle's Heterogeneous Services (HS). I have a database link to a Microsoft Access table called employee. From an Oracle connection using SQL*Plus, I can describe the table's columns and datatypes (desc employee). I can also select…
steve4321
  • 33
  • 1
  • 9
1
vote
0 answers

Connecting Oracle to Microsoft SQL Server on 2 different servers

I am trying to make a connection between Oracle and SQL Server to insert some values from Oracle into SQL Server. I have 2 questions which i was hoping you can help. There is a stored procedure created in Oracle 11g database. It joins a few tables…
Mojatba
  • 39
  • 1
  • 5
1
2