Check out this article by Vikram Das about how to read OS environment variables using PL/SQL.
I did not know that!
NB! If you want to move to the "New World" - and benefit from the awesomeness of Hadoop, without having to re-engineer your existing applications - check out Gluent, my new startup that will make history! ;-)