Re: adodbapi and output parameters in stored procedures

2008-11-08 Thread M.-A. Lemburg
On 2008-11-07 17:32, [EMAIL PROTECTED] wrote: > Thanks for that excellent pointer! > > I was able to do just what you said with > > But if my procedure has an insert statement in its midst, it doesn't > work. The cursor.fetchall() gets an exception. > Any ideas? Try this (I haven't checked that

Re: adodbapi and output parameters in stored procedures

2008-11-07 Thread Roger Upole
<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > > I need some help getting output values from my stored procedures when > using adodbapi. There's an example > testVariableReturningStoredProcedure in adodbapitest.py, and that > works for my system. But my stored procedure

Re: adodbapi and output parameters in stored procedures

2008-11-07 Thread leesquare
Thanks for that excellent pointer! I was able to do just what you said with But if my procedure has an insert statement in its midst, it doesn't work. The cursor.fetchall() gets an exception. Any ideas? --Li -- http://mail.python.org/mailman/listinfo/python-list

Re: adodbapi and output parameters in stored procedures

2008-11-07 Thread M.-A. Lemburg
On 2008-11-07 15:04, [EMAIL PROTECTED] wrote: > Hello, > > I need some help getting output values from my stored procedures when > using adodbapi. There's an example > testVariableReturningStoredProcedure in adodbapitest.py, and that > works for my system. But my stored procedure also inserts an