I am migrating an Oracle DB from v7.3.4.4 to v8.1.6.2 on AIX4.3.3.
Procedures and functions that use database links to a v7-database yield
"PLS-00907: cannot load library unit" when I try to recompile them. With
this are mentioned the objects that are supposed to be granted over the
dblink (the "library units").
Whatever I try to do (drop and remake the dblink, create new synonyms,
grants on everything which is referenced in the invalid object), nothing
works.
Metalink has only a terse acknowledgement of this problem and offers a
bogus solution ("Provide the needed library unit" - doh!).
Anyone has experience with this?
Tia,
Jos van Raamsdonk (j.van.r...@nospam.centraal.boekhuis.nl)
Centraal Boekhuis BV
Netherlands.
I believe in many cases it is better not to use database links inside your
pl/sql but instead create the whole procedure remotely and run it remotely.
Shouldn't the problem disappear when you have upgraded all of your
databases?
Hth,
Sybrand Bakker, Oracle DBA
"Sybrand Bakker" <pos...@sybrandb.demon.nl> wrote in message
news:tad8aqf...@beta-news.demon.nl...
Anyway, I will give Oracle a call and open a new TAR. In the meantime,
if there are more suggestions, I will gladly contemplate them!
Thanks guys,
Jos.
-----Oorspronkelijk bericht-----
Van: William Bailey [mailto:billba...@netzero.net]
Gepost om: donderdag 8 maart 2001 2:27
Gepost naar: misc
Discussie: PLS-00907: cannot load library unit
Onderwerp: Re: PLS-00907: cannot load library unit
bye,
Jos van Raamsdonk.