Re: a row-level operator for copying?

Mark Harrison schrieb:
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



Names -> dba_procedures
Parameters -> dba_arguments

You won't be able to call any procedure via cursor.callproc if any of arguments is a type unsupported by cx_Oracle (like collection types)

Best regards

Maxim
.

Relevant Pages

  • Re: introspecting stored procedure parameters?
    ... like to generate these automatically by introspecting the database ... Any clues as which tables to look at, ... After all Usenet is a volunteer ...
    (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)