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 -> Database Link Error

Database Link Error

From: Ned Wilson <nwilson_at_bdsinc.com>
Date: Wed, 10 Jun 1998 12:15:49 -0400
Message-ID: <MPG.fe87b417c006678989680@news.connix.com>


when i try to connect to a database on an nt machine from a solaris db using a stored function created in sql navigator pro, i get an error message, the text of which i relate below.

ORA-04052: error occured when looking up remote object BIN.ADDRESS_EMERGENCY_at_BIN.WORLD
ORA-04029: error ORA-904 occured when querying ORA_KGLR7_IDL_SB4_at_BIN.WORLD
ORA-00604: error occured at recursive SQL level 1 ORA-00904: invalid column name

i am doing a basic select statement, trying to retrieve information from the database instance bin. i have created db links to and from bin in the public schema, so the links should be accessable to everyone. what am i doing wrong here?

-ned Received on Wed Jun 10 1998 - 11:15:49 CDT

Original text of this message

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