Re: importing dblink problem

From: Marcus N Hofer <markus_at_tk136248.telekabel.at>
Date: Mon, 28 Sep 1998 09:30:36 +0200
Message-ID: <360f3b76.0@news.telekabel.at>

what errmessage do you retrieve if you try to recompile one of these packages with
'alter package XXXX compile;' ?

maybe the code uses synonyms using some other dblink that is no longer valid.
the errmessage above should return the name of the offending dblink.

--marcus

Doug Cowles schrieb in Nachricht <360EC359.95021098_at_i84.net>...
>I do a small import regularly.. and every time, a series of packages and
>
>procedures refuse to compile because of the absence of a database link.
>I assumed it was because the database link was imported after the
>packages,
>so they only would have to be recompiled - but even if I create the link
>
>first (and it is definitely valid), this part of the import (the last
>part), always fails.
>In addition, the packages don't import and sit with an invalid status,
>they just
>don't come in.
>
>Any suggestions?
>
>dcowles_at_i84.net or
>dcowles_at_bigfoot.com
>
Received on Mon Sep 28 1998 - 02:30:36 CDT