Carsten Broschek wrote:
> Hi,
>
> I am facing problems accessing views on a remote database
> via database-link.
>
> The link is established and query of the remote views via
> sqlplus works fine.
>
> The same query implementend in a pl/sql packages causes
> errors, and the package does not even compile.
>
> Errors are:
>
> "..deadlocks when looking up remote object"
> ora # 04052, # 04020
>
> Any ideas?
>
> Thanks in advance,
>
> carsten
Does your Oracle have a version and edition?
Were privileges granted explicitly or through a role?
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Jun 21 2004 - 21:58:41 CDT
