O'Reilly logo

Expert PL/SQL Practices for Oracle Developers and DBAs by Riyaj Shamsudeen, Robyn Sands, Michael Rosenblum, Stephan Petit, Arup Nanda, Connor McDonald, Torben Holm, Sue Harper, Dominic Delmolino, Lewis Cunningham, Ron Crisco, Melanie Caffrey, Martin Büchi, Adrian Billington, John Beresniewicz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

C H A P T E R  15

Dependencies and Invalidations

by Arup Nanda

Dependencies between PL/SQL packages can a perplexing source of application errors. Database administrators and developers unacquainted with how dependencies work can find themselves scratching their heads over sporadic and unrepeatable errors that are seemingly without cause. For example, while executing a procedure in a package you are responsible for, an application throws the following error:

ORA-04068: existing state of package has been discarded

This particular procedure has been executed a million times before. You can swear on your great grandmother's grave that you haven't changed the package in a long time, definitely not in the last few seconds and yet the application ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required