title: How to retrieve the body of an Oracle procedure or function
body: <p>What I'd like to be able to do is retrieve the schema information for subprograms, functions, package specifications and package bodies from an Oracle 9i database so that I can present them to the user in a C# client using the classes in the System.Data.OracleClient namespace. </p>
  
  <p>So far, I've been able to display the high level schema data far faster than Java applications can, but the packages and functions are beyond my grasp. I can show the columns, their types, the indexes, table- and column level comments, and all sorts of <em>really</em> useful information in really useful ways. Now, if I could just get to the procedures.</p>