Re: Database Link Error

What your seeing here is an Oracle error stack, where typically the last error product code/number line describes the root cause. In your case, your SQL statement has referenced an unknown, mispelled, or inaccessible column.

Ned Wilson wrote:

> 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 Thu Jun 11 1998 - 20:33:19 CDT