Re: how do I call a package through a dblink?

B.- wrote:
> 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!!

Please read the error message carefully, preferably before just dumping it.
Doesn't ora-1017 tell you anything? How did you set up the database link?

-- 
Sybrand Bakker
Senior Oracle DBA