RE: Privilege Issue

 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.

--
http://www.freelists.org/webpage/oracle-l