How to Reference Package Variables in SQL

A long time ago (pre-12c) I wrote about {% post_link how-to-reference-package-variables %}. This technique used an execute immediate function to reference a given package variable. Another alternative at the time was to create individual get function...