Skip to content

Provide a non DB-api compliant callproc #154

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
GoogleCodeExporter opened this issue Mar 18, 2015 · 1 comment
Open

Provide a non DB-api compliant callproc #154

GoogleCodeExporter opened this issue Mar 18, 2015 · 1 comment

Comments

@GoogleCodeExporter
Copy link

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,
})

Original issue reported on code.google.com by sad.n...@gmail.com on 4 Feb 2011 at 2:30

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant