Yep, 9i has that cool (and easy to use) compile natively feature which is a big win for stuff that's computationally expensive. AskTom has an
interesting discussion around this (although it talks more about implicit vs explicit cursors, but I still found it interesting).