• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

PL SQL Package Invalidated

 
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi All

Suppose there is a package "X" being used by the application (application hosted in WAS)

now for some requirement/urgent production patch the definitions of the PL SQL package(oracle) is changed (addition of one if condition) , now when the package is called form application it gives package was not correct/invalid state (input/output arguments are not changed only functionality), but the package is valid


But if the same package is called again it works, the only issue now is why it failed first time.

Also after executing the package and if the servers are bounced this issue does not occur

can some one help on why such behavior

Thanks in advance
 
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
That is the expected behaviour, so that client can understand that the package has been changed. You see "ORA-04068: existing state of packages has been discarded"
message thrown. You don't compile packages in production so often, except deployments.
 
Screaming fools! It's nothing more than a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic