make sure that the x1@d1 has execute privs on that package. Where x1 is the user you are trying to connect thru db-link from d2. Raj On 11/3/05, Subbiah, Nagarajan <Nagarajan.Subbiah@xxxxxxxx> wrote: > > Hi, > > I am getting an ORA-904 invalid identifier error when calling a package > over the db link. > Database D1 has a package P1 and Database D2 has the synonym S1 for the > package P1 over the db link. When I call a function F1 in the package P1 > using the synonym S1 from D2, > "Select S1.F1('123) from dual; " I am getting the above error ORa-904. > What privilege I am missing and Can we not access the package over the db > link? > Don't have any issue with accesing the tables. > Thanks, > Raja. > > -- ------------------------------ Useful Links: FAQ1, FAQ2, RTFM, STFW, ORA-600, ORA-7445