Skip to Main Content

Oracle Forms

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 I USER OTHER USER TABLE IN FORM AND REPORT BY SYNONYM

User_OYQDCJul 29 2016 — edited Jul 29 2016

hi master

dear i use this code

CREATE PUBLIC SYNONYM firstsyn FOR firsttable;

in abc user because abc user have firstable

that code run fine without any error

i connect xyz in sql developer

i checked in sql developer by this query (with xyz user)

select * from firstsyn;

this query run and give me data without any error

but i connect oracle forms 6i and report by xyz user

that connect but not show the any table (firstsyn or firsttable)

please give me idea how i use this synonym or other user table in form and report

regard

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2016
Added on Jul 29 2016
5 comments
264 views