Last week I saw a PL/SQL teaser tweet by Steven Feurestein (@sfonplsql):
#PLSQL teaser: can you build a package that compiles w/o error, spec contains >1 procedure, but none of them can actually be executed?
— Steven Feuerstein (@sfonplsql) April 1, 2015
The question sounded simple: can you build a valid package with header and body with more than one procedure – that can compile but can never run. That was a really interesting question and I found myself thinking about it while working.
Since it is really had some good things we could learn from it, let’s go over my thought process and get to know this unique PL/SQL behavior.