Carsten Broschek wrote:
> 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.
Because compiled code requires the explicit granting of privs.
SQL*Plus does not.
--
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 Tue Jun 22 2004 - 08:59:45 CDT
