My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 154: Provide a non DB-api compliant callproc
1 person starred this issue and may be notified of changes. Back to list
Status:  Investigating
Owner:  ----


 
Reported by sad.n...@gmail.com, Feb 4, 2011
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
(No comment was entered for this change.)
Status: Investigating

Powered by Google Project Hosting