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

Home -> Community -> Usenet -> c.d.o.misc -> VIEW via database link

VIEW via database link

From: Carsten Broschek <cbroschek_at_web.de>
Date: Tue, 22 Jun 2004 00:09:16 +0200
Message-ID: <2jp4l1F14brbtU1@uni-berlin.de>


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 Received on Mon Jun 21 2004 - 17:09:16 CDT

Original text of this message

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