Home > Default > Can Apex 4.1.1 see non-Oracle tables across dblinks using gateway?

Can Apex 4.1.1 see non-Oracle tables across dblinks using gateway?

November 30Hits:0
Advertisement
OS: Windows7 64-bit
APEX: APEX 4.1.1
OracleXE: 11gR2
Oracle ODBC Gateway: 11gR2
Remote DB: Sybase Anywhere 10
=====================
When trying to develop an application (e.g. interactive report), APEX does not see tables from remote database even after public synoym is created in local OracleXE schema that current workspace points to?
I can with no issues -- via APEX SQL Workshop -- run SQL that accesses the remote database tables through the dblink.
Any suggestions?

Answers

user601798 wrote:
When trying to develop an application (e.g. interactive report), APEX does not see tables from remote database even after public synoym is created in local OracleXE schema that current workspace points to?
I can with no issues -- via APEX SQL Workshop -- run SQL that accesses the remote database tables through the dblink.
Any suggestions?Create a view on top of the synonym.
Apex can work with the views. It does not work well with synonyms. But keep the synonym, since that makes your view indepentent of the name of the DB link.
So the typical recommened structure would be:
<pre>
remote database table
-> access via db link
-> synonym on remote table
-> View on Synonym
-> Apex uses View (Wizards etc.)
</pre>
If using a non oracle DB you might come across problem with certain concepts like ROWIDs. Obviously cyou can't build a form depending on a rowid, when working with a non oracle database. It should work with a normal primary/unique key however.
Edited by: Sven W. on Aug 15, 2012 12:46 PM

Read other 4 answers

Tags:

Related Articles

  • Can Apex 4.1.1 see non-Oracle tables across dblinks using gateway?November 30

    OS: Windows7 64-bit APEX: APEX 4.1.1 OracleXE: 11gR2 Oracle ODBC Gateway: 11gR2 Remote DB: Sybase Anywhere 10 ===================== When trying to develop an application (e.g. interactive report), APEX does not see tables from remote database even af

  • Can I use APEX directly read/sync with the Oracle Tables ?November 30

    We have a Oracle Database to manage the design data.I am trying to setup a web-based front end using APEX to manage & monitor the parts ordering & logisitics.I want to drive the master data directly from the database without any export or data tra

  • Is Oracle Apex 4.2.3 certified with Oracle EBS 12.1.3?October 11

    Is Oracle Apex 4.2.3 certified with Oracle EBS 12.1.3?Yes it is certified as outlined in the Extending Oracle E-Business Suite Release 12 Using Oracle Application Express white paper. Within this white paper the Prerequisites listed are: Oracle E-Bus

  • Can Apex 3.0 be installed on Oracle 9.2.0.1  on Windows ?November 30

    Can Apex 3.0 be installed on Oracle 9.2.0.1 on Windows ?Application Express requires Oracle Database Server 9.2.0.3 or higher. The 3.0 doc erroneously says 9.2 where it should say 9.2.0.3. This has already been noted as something to be corrected. Sco

  • Is the APEX 2.2 hosted on the oracle site only for windows machineNovember 30

    Hi, Is the APEX 2.2 hosted on the oracle website only for the windows machine. Can I download the APEX 2.2 s/w for a linux box as well. Kindly let me know if a linux version is available anywhere else. Thanks.Hello, ApEx is running inside the databas

  • Does Apex 4.1 / 4.2 supports Oracle BI PublisherDesktop version 11.1.1.6 ?November 30

    Hi Apex Experts, Does Apex 4.2 release (apex.oraclecorp.com) is compatible with Oracle BI PublisherDesktop to version :11.1.1.6 ? Old version of Oracle BI PublisherDesktop (it was 10.some thing) was working fine till last week, but currently its show

  • Installing Apex 3.2 into 10g UNIX Oracle instance ... prods installed?November 30

    Using this script ... as between dashed lines ... in my existing, running Apex instance on a Win2k3 server ... set linesize 150 set pagesize 100 column comp_id format a25 column comp_name format a75 word_wrapped column version format a20 select comp_

  • How to upload above20000 records csv files into oracle table,Oracle APEX3.2October 11

    Can any one help me how to CSV upload more than 20,000 records using APEX 3.2 upload process.i am using regular upload process using BOLB file SELECT blob_content,id,filename into v_blob_data,v_file_id,v_file_name FROM apex_application_files WHERE la

  • Any tricks to store pdf file generated via jasper to oracle tables.October 11

    i need to generate pdf file ..for records in a cursor.. So i use jasper integration kit ... to accomplish the same... issue is .. i need to press a button and then pdfs file shoudl be generated...and stored in a table as a blob..My process does this.

  • Insert a oracle table from jquery/ajaxNovember 30

    Hi. i am new on apex and will like to know if can help me with my question. i am calling an on demmand process from jquery javascript to insert some data on oracle apex_collection (i do delete and insert on the apex collection and works fine) , but i

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 15 q. 0.913 s.