Re: introspecting stored procedure parameters?

On Fri, 27 Jul 2007 19:22:30 GMT, Mark Harrison <mh@xxxxxxxxx> 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
.

Relevant Pages

  • Re: a row-level operator for copying?
    ... Mark Harrison schrieb: ... like to generate these automatically by introspecting the database ... Any clues as which tables to look at, ...
    (comp.databases.oracle.misc)
  • Re: introspecting stored procedure parameters?
    ... like to generate these automatically by introspecting the database ... Any clues as which tables to look at, ... You could also consider to use the dbms_describe package. ...
    (comp.databases.oracle.misc)
  • Re: Object or class does not support the set of events?
    ... The decompile tip was very beneficial--big ... Recreating the database and importing didn't ... Not too much out here for clues as to what's wrong. ... > The event procedure can even be EMPTY, ...
    (microsoft.public.access.forms)
  • Re: OracleClient Connection string ..
    ... Any clues why? ... > Not off of the top of my head, ... > sure you can make the connection. ... Service Name refers to the name of the database - if you are using local ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: backup ultilities
    ... mikePOST@xxxxxxxxxxxxxxxxxxxxx (Mike Rosenberg) wrote: ... database. ... There were clues enough in my original post and followups for you ...
    (comp.sys.mac.apps)