> I am having difficulty inferring how to invoke a dbproc from within a
> python script. I can call a dbproc that returns a cursor using the
> session.sql("call someproc") function. However, I can't figure out how
> to handle in/out/inout parameters this way. What am I missing?
Assuming you have dbproc with three input and two output parameters:
out0, out1 = session.sqlX ('call someproc (?, ?, ?, ?, ?)', [in0, in1, in2])
or
procCall = session.prepare ('call someproc (?, ?, ?, ?, ?)')
out0, ou1 = callProc.execute ([in0, in1, in2])
It is currently not possible to call a dbproc which returns both a result
set and output parameters.
Daniel Dittmar
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
http://www.sapdb.org
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
