Re: introspecting stored procedure parameters?

From: <sybrandb_at_gmail.com>
Date: Fri, 27 Jul 2007 23:00:19 +0200
Message-ID: <g4nka35g08ftb5ldgitbalqon1drlp5g0v@4ax.com>

On Fri, 27 Jul 2007 19:22:30 GMT, Mark Harrison <mh_at_pixar.com> wrote:

>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

Also you should preferably avoid to post queries multiple times when answers don't come right away. After all Usenet is a volunteer business.

Sybrand Bakker
Senior Oracle DBA Received on Fri Jul 27 2007 - 16:00:19 CDT