APEX Oracle RDB Database Link

From: MacGregor, Ian A. <ian_at_slac.stanford.edu>
Date: Thu, 13 Aug 2009 14:44:06 -0700
Message-ID: <7F24308CD176594B8F14969D10C02C6C0331ACC3_at_exch-mail2.win.slac.stanford.edu>

I have a system running on an Oracle database which needs to get information from an RDB database. When connecting to the RDB version from the Oracle database server, RDB displays the following

Connected to:
Oracle Compatible Release
Oracle Rdb OCI Server Release - Production, Level 1.7 Oracle Rdb SQL Release - Production

So the "compatible" is off. I want to use a database link to pull data from the RDB database to the Oracle database. I created a database link and all works well. The next test was to see if the link would work from an APEX application. It does not. Insufficient privilege error is returned from the RDB database. I tried hiding the link in a view, creating a public database link and so forth, but a 1031/2068 error is always returned. I even tried making the link as APEX_PUBLIC_USER, and got the expected error that the remote database or words to that effect could not be found.

Any ideas? I have not worked with RDB before.

Ian MacGregor
SLAC National Accelerator Center

Received on Thu Aug 13 2009 - 16:44:06 CDT

Original text of this message