Sitemap

Amicuk Programming Answers

Accessing Tables via Database Links.

-0001-11-30   Views:0

Advertisement

Hello. I have created a database link in order to allow me to access tables that exist in a database separate from the one that APEX exists on. The link seems to work because I can query these tables in the APEX SQL Commands windows by running the fo

Hello. I have created a database link in order to allow me to access tables that exist in a database separate from the one that APEX exists on. The link seems to work because I can query these tables in the APEX SQL Commands windows by running the following command,
Select * from [email protected]_link;
However, when I try to create an application in Application Builder, these tables do not seem to be accessible. Also, I can't see them in the Object Browser. I believe this problem is related to db permissions of some sort, but don't know how to correct it. Thank you for your help.

The replay answer
Advertisement
Hello:
The kind of view tht you have created is updateable.
You can create an APEX form to do DML against this view much like in the manner you would create a form against a table.
The link below might help
Re: Cannot build form off from view?
Varad

Go to See the other 7 answers

Accessing Tables via Database Links.

Category:DefaultRelease time:-0001-11-30Views:130

Hello. I have created a database link in order to allow me to access tables that exist in a database separate from the one that APEX exists on. The link seems to work because I can query these tables in the APEX SQL Commands windows by running the fo[More]

Error while trying to access table using DB Link

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I had to access a table in another instance using a DB link. As there was no DB link, I was asked to create one and then access the table. The below query was used to create DB link on my current instance FDEV: CREATE PUBLIC DATABASE LINK to_[More]

Using Interactive Report with SQL query accessing tables via db link

Category:DefaultRelease time:2015-10-11Views:130

Is there a known issue with using the interactive report in version 3.1.2.00.02 with SQL that is accessing tables via a database link? I get the error 'not all variables bound', I do not get this error when using the standard report for the same SQL?[More]

Accessing Tables using DB link .

Category:DefaultRelease time:2015-10-11Views:130

Hello Friends, I have a development and production env. I created a public DB link in Development say mylink . Trying to access the developement table from production using the following command say to access table x From PROD accessing DEV table x u[More]

Query builder: tables from Database Link

Category:DefaultRelease time:-0001-11-30Views:130

Hi APEX people, Is there a way to use tables from a (remote) Database Link in the Query Builder? In the Query Builder I seem to have only access to locally (schema) stored tables. I already tried to define a Synonym for the remote tables I wanted to[More]

Proc fails with sqlcheck=full accessing tables across a link to non 11g db

Category:DefaultRelease time:-0001-11-30Views:130

I am trying to compile programs that were upgraded from 9i to 11g and having issues whenever I try to compile code that accesses non 11g databases across a link when sqlcheck is anything other then syntax. If I have a select such as select distinct a[More]

Query to table in Database Link returns value from local table

Category:DefaultRelease time:-0001-11-30Views:130

Hi I made a databaselink (Create database link db_a.world connect to db_a identified by <user> using 'db_a.world') Then I query a table, connected as a user in db_b.world (this is our developer database - identical to db_a): Select count(*) from tab[More]

Query a remote table with Database Links

Category:DefaultRelease time:-0001-11-30Views:130

How do database links work with ODP.NET? The following code produces an "ORA-02041: client database did not begin a transaction" error on the Fill method. SQL (in acme instance): CREATE DATABASE LINK sales.hq.acme.com CONNECT TO scott IDENTIFIED[More]

About database link

Category:DefaultRelease time:-0001-11-30Views:130

i am able to access a database link from development database .But i am not able to access that same database link from test database. is it firewall issue or do i need any grants ? Thank you in advance ..Hi, A database link works only within the dat[More]

Sql query across multiple tables ina database

Category:DefaultRelease time:-0001-11-30Views:130

I have 3 MS Access tables in database that are linked by keyed fields in the table.  Is there a way to fetch only certain records that match a criteria across all three of these tables using the database connectivity toolset VIs?Thanks.  I am trying[More]

Calling SQL Server Function from Oracle Database link

Category:DefaultRelease time:-0001-11-30Views:130

Hi , i have some data from a old SQL server i would i can access with a database link but i cant call function from my database link. i would like to do something like @SPAN_PROD = Database link _EnerttObtApReelBassSys is a Table function from my SQL[More]

Hot
When using my new ipad 4 retina display when on the Internet many of the images are blurry or low resolution? But if you go on apples website everything is crystal clear?? Why is this?Ebay images look fine on mine. Image zoom doesn't work, but that's [More]
Hello All, I am developing a sample ADF application. Database is MS SQL Server 2005 SP2. I get below error message. I am trying in parallel to google it... However trying here if any encountered such an issue and had resolved it. Thanks in advance fo [More]
Server Error in '/' Application. Configuration Error  Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file app [More]
Hi, I am new to UIX/JDeveloper and having a problem with MessageRadioSet-PPR. I am using switcher with two cases. I am not able to set up an event for it, so that it will change itself. If I put the childdata name myself it works fine. Can anyone tel [More]
Hello all, I'm new to Java and hope to learn a lot about the language. I've lost much sleep over this last program I was assigned to complete. I've tried everything to try and get this program working properly. As a school assignment we are required [More]
I'm trying to make a flash page that shows a map with a car driving around on it. The car can be moved with keyboard or mouse, doesn't really matter. When the car crashes into a building, I want it to change to a different page. How can I do this? Th [More]
Hi SRM experts, I'm working on SRM7.0 and have the following issue: Tcode: PPOMA_BBP Tab: Extended Attributes Radio button: Storage Locations I am able to select my R/3 backend system from drop down but unable find any entries for Storage Locations i [More]
Are longer power cords available rather than the standard 6-footers? If not, does anyone have a solution that would get me to at least 8 feet? Thanks.Sure voltage drops off over long distance; but as all Macs have auto-switched power supplies capable [More]
I am in the process of developing a online flash module for a client and have been having some problems with the screen reader actually reading the text on the screen. The text is in a classic dynamic text field. The field is covered by a number of l [More]
Hello all,           I have an unusual requirement . Part of my Java applet has parameters           like this.           I am embedding this java applet into a JSP page           << portions of applet reproduced below>>           VALUE = '    [More]