1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How i user other user table in form and report 6i

Discussion in 'Oracle Forms and Reports' started by mfahim, Jul 29, 2016.

  1. mfahim

    mfahim Active Member

    Likes Received:
    Trophy Points:
    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