Daniel Morgan wrote:
> 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?
>
oracle 8.1.7, access for the views are granted explicitly.
query of a remote stored function via the link implemented
in pl/sql works also. seems to be a problem with the views,
but why works direct query via sqlplus?
c.
Received on Tue Jun 22 2004 - 02:19:34 CDT
