Urgent: DCOracle2 + stored procedure parameters

Gerhard Häring gerhard.haering at opus-gmbh.net
Fri Aug 30 18:06:55 CEST 2002

Ruslan Spivak wrote:
> Hello python-list users,
> Could anybody explain me the following:
> I need to pass to stored procedure about 40 parameters - ugly,
> is it possible to pass a record or similar from python to stored
> procedure (DCOracle2)

I'm not very experienced with DCOracle2, I'm currently using it like this,
with named parameters:

    cursor.callproc("someproc", PN_PROJ_ID=42)

So if you already have a dictionary that maps your parameter names to the
values you want to pass to the SP, you could use this form:

    parms = {"PN_PROJ_ID": 42, "PN_FOOBAR": "baz"}
    cursor.callproc("someproc", **parms)

Now I have a question - how are these forms of argument expansion (*args,
**kwargs) called in Python?

More information about the Python-list mailing list