Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How a Synonym works in APEX

567811Oct 22 2008 — edited Oct 27 2008
I have been trying to set up a table for users to Insert, Update, or delete. This table is in a synonym from another schema and I can't get it to show up how I would like so that the users can modify the table.

When I look at the synonym from the Object Browser, I can not see any fields, Is this Correct?

I would like to show the fields for this table in a tabular form for update, but the forms only accepts tables unless you use a SQL query, Is there a way to show a synonym's fields in a form for Update, Insert, or delete?

Whwn I use a sql query for the synonym, no values shw up when I run the form, any reason why?


Thanks
Rob
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2008
Added on Oct 22 2008
5 comments
1,177 views