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