Re: recompile package body with invalid db link references

  • From: Juan Carlos Reyes Pacheco <jcdrpllist@xxxxxxxxx>
  • To: Patrice Boivin <patrice.boivin@xxxxxxxxx>
  • Date: Fri, 17 Apr 2015 15:01:12 -0400

10g always ask for invalid database links, sometimes happens it allows,
even in 11g, but usually when you decompile, then to recompile always check
the links.
The only choice you have is execute immediate to use invalid links, and
because it allows binding it's ok.

2015-04-17 10:18 GMT-04:00 Patrice sur GMail <patrice.boivin@xxxxxxxxx>:

I noticed that in 10g, one could recompile a package body with invalid
database link references, but that 11g is more thorough: If a reference no
longer works it refuses to compile the package body.


-- Patrice
My profiles: [image: Facebook]
<http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image:
LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image:
Twitter] <http://www.twitter.com/PatriceBoivin>
<http://www.twitter.com/PatriceBoivin>
Signature powered by WiseStamp <http://www.wisestamp.com/email-install>

Other related posts: