Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how do I call a package through a dblink?

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

From: sybrandb <sybrandb_at_gmail.com>
Date: 7 Nov 2006 11:48:09 -0800
Message-ID: <1162928888.855938.78170@b28g2000cwb.googlegroups.com>

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
Received on Tue Nov 07 2006 - 13:48:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US