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

On Nov 7, 2:48 pm, "sybrandb" <sybra..._at_gmail.com> wrote:
> 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_PACK..._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- Hide quoted text -- Show quoted text -

Creating and using database links is covered in the DBA Administration manual. Either the user Id and/or password in your fixed user database link was incorrectly setup or does not exist in the target database. For a current user link your username and password would have to exist in the remote database.

HTH -- Mark D Powell -- Received on Tue Nov 07 2006 - 19:14:36 CST