nick.mcdermaid (10/14/2010)
I'm impressed with Oracle packages as they almost seem like classes to me-Variables which 'reflect' existing table meta data
-Custom data types
-Multiple 'methods' within the package all returning different types
...and you are absolutely correct.
Are you old enough to remember Ada - the programming language? packages come from there.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.