How to call a oralce stored procedure (Package),function from oracle link server?

I did the following:

select link_server_name..schema_name.MyFunc('tom')

I got the following error message:
The object name contains more than the maximum number of prefixes. The maximum is 2.

You got to resolve the prefixes correctly. it doesnt recognize .. the correct prefix is servername.dbname.ownername.functionname
I think you missed one.

_________________________
- Vijay G
Strive for Perfection