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
I can no longer drag an image from my browser (Chrome or Safari) directly into Photoshop CC, Mail and other programs like I could in the past. I now must drag the item to my desktop first, and then drag it into the program. I don't know when this beh [More]
It's been happening for awhile now. I can FaceTime from my mac just fine it only happens with my iPhone 4. I'd appreciate some help.Being the FaceTime only works over wifi i'd suspect your wifi router is the problem Try updating it's firmwareRead oth [More]
I get a lot of e-mails with pictures or other graphics embedded in the e-mail but I can't seem to be able to insert my photographs or any other graphic information into new e-mails I want to create. How do I do this?Firefox doesn't do email, it's a w [More]
Hi I am importing to Pictures/2010/date of shot If viewed in explorer everything is fine. It created the correct subfolders and moved the pictures into it. However, in the folder structure in the Library panel the new folders are located at the root [More]
I've got quite a problem here. We are using a large LabVIEW application (written by me) for years now on different test benches. The software changes a lot because we have to change our tests a lot. So far we had no problems since the time it was run [More]
I am writing an application for a mysql database where in I have to populate some very old data in to the database.For that I need to convert dates from the format "MM/dd/yy" into the format "yyyy-mm-dd"( this format being used in mysq [More]
Linux Mandrake 7.02 / Sun SDK 1.2.2 SE / Tomcat 3.1 / Oracle 8.0.5 / JDBC 1.2.X I've got a table which have a LOB column. I want to retrieve this LOB. When I do it in a java program, all is well, I get the image in the LOB. When I put the code in a s [More]
hi, I have an iphone 3gs i have some ibooks from uni (with .ibook extension) i can add these books to itunes library but when i try to sync my ibooks it would not show anything to sync! has anyone faced this problem before? or is there a solution for [More]
Dear All, Im having the table like the following, i need ther report like if i give role ,region and segment mean then i need onmenuid 2 alone. if input is role and region alone the i need those combinations result alone . if the input is role alone [More]
Hello. I'm not technically savey and am in need to assistance in resolving an issue. I suddenly am no longer able to access my GMail account. The system will not accept long-used password. I'm working back through GMail assistance forum and was told [More]