• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1395
  • Last Modified:

DB link in Oracle Application Express

Hi,
I am working on Oracle application express, i am quite new to it.  I need to develop a simple data entry form, for the tables that reside in an another database, i have created dblink for that in the, but i am unable to locate the table for that database for a form in the wizard. But i am able to generate reports from the tables of that database using the dblink.
 I am unable to create a form is that because the the oracle application express forms doen't support  or i am doing it in a work?

is there any other way in which i can create data entry form for tables in a remote data base?
0
vishali_vishu
Asked:
vishali_vishu
  • 2
1 Solution
 
schwertnerCommented:
The user you use has to have to privilege to see the table.
I think it is privelege problem.
Reports need only select privelege, but forms needs also insert, update and delete privelege.
0
 
schwertnerCommented:
Good luck!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now