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: DB link

Re: DB link

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 31 May 2002 02:21:19 -0700
Message-ID: <1e8276d6.0205310121.3ec642d4@posting.google.com>


"Petr Sobotka" <petrsobotka_at_yahoo.com> wrote in message news:<ad6bpj$1hv$1_at_av2.rz.fh-augsburg.de>...
> I have a problem with database links in Oracle 8.1.7.
> I created a link of type "current user" (which I need). Than when trying to
> compile a PL/SQL which uses the link I get the following messages:
>
> ORA-04052: error occurred when looking up remote object ...
> ORA-00604: error occurred at recursive SQL level 1
> ORA-28030: Server encountered problems accessing LDAP directory service
>
> If I create the link as "connected user" this error does not apear.

Looks like you have, in your database, installed an Advanced security option.
When ASO has been installed you can't use a database link with current user.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Fri May 31 2002 - 04:21:19 CDT

Original text of this message

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