how do I call a package through a dblink?

I have two databases: db1 and db2, and I need to use some data which is in db2, with a package which is in db1. Since the query is extremely slow on the dblink, I created a package in db2. In it there is a procedure which I need to call from db1. How can I do it?

I created a synonym like this

create public synonym user_something for user.something_package_at_db2

Now, how do I use it?

When I call it like this:

      user_something.procedure(parameter1, parameter2, ... parameterN);

I get this error:

04:42:39 p.m. Error: ORA-04052: error occurred when looking up remote object
USER.SOMETHING_PACKAGE_at_DB2.WORLD

04:42:39 p.m.  ORA-00604: error occurred at recursive SQL level 1
04:42:39 p.m.  ORA-01017: invalid username/password; logon denied
04:42:39 p.m.  ORA-02063: preceding line from db2

I need this to go on, and nobody here seems to know what to do... can you help me?
Thanks!! Received on Tue Nov 07 2006 - 13:43:57 CST