introspecting stored procedure parameters?

I need some python wrappers for some stored procedures and would like to generate these automatically by introspecting the database to get the names of procedures, functions, and their parameters.

Any clues as which tables to look at, and any other hints are most appreciated.

example python function, using the cx_Oracle package:

    def myproc(self,name,address,phone):

        r=self.cursor.callproc('myproc',[name,address,phone])
        return 0

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios