Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: a row-level operator for copying?

Re: a row-level operator for copying?

From: Mark Harrison <mh_at_pixar.com>
Date: Fri, 27 Jul 2007 19:13:20 GMT
Message-ID: <ktrqi.53370$5j1.23103@newssvr21.news.prodigy.net>


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
Received on Fri Jul 27 2007 - 14:13:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US