• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

PL SQL Package Invalidated

 
rudreshashok kumar
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • 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
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic