Database Networking (MOSC)

MOSC Banner

APEX can't see tables and sequences pointed to by synonyms

edited Aug 17, 2009 2:45AM in Database Networking (MOSC) 5 commentsAnswered
Hi,

I hope this question is posted to the right "community." I couldn't see any appropriate heading for my question, so I am posting where I've seen other APEX questions.

I am trying to develop an application in Application Express using tables and sequences that are in a remote database. I have a database link to the remote schema and have created synonyms for all the tables and sequences. But when I go to create a form or report the remote tables do not come up in the list of available tables.

I can create a local view of the remote tables and I can create a form on the view, but I still can't select the sequence.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center