| Issue 154: | Provide a non DB-api compliant callproc | |
| 1 person starred this issue and may be notified of changes. | Back to list |
In some cases it would be immensely useful to call stored procedures which set output parameters. I don't think it would hurt that much to introduce some ability to indicate the parameter direction. I've tried implementing something like this for adodbapi and it seems to work.
# inside adodbapi:
class Inp(str):
direction = adc.adParamInput
class Out(str):
direction = adc.adParamOutput
class InOut(str):
direction = adc.adParamInputOutput
# to be used like this
from adodbapi import Inp, Out
cursor.callproc('GetOrderStatus', {
Inp('IdOrder'): 1327844,
Out('OrderState'): 0,
})
Feb 27, 2011
Project Member
#1
mkleehammer
Status:
Investigating
|