MySQL Forums
Forum List  »  Connector/Python

Stored Procedures and python
Posted by: Brett Dixon
Date: November 09, 2007 12:25PM

So i have been trying to get my stored procedure to work with python all day. The stored proc works from the query browser just fine. and it kinda works in python. Right up to the point i have to commit(). So it will run the procedure, return the desired results and everything is fine. But when i do a db.commit() MySQL errors saying "Commands out of order, you cannot run this command right now" or something close to that.

I have tried everything i can think of and nothing will let me commit. I have tried the cursor.callproc() method, which works to the same extent. It runs the proc just fine, but i cannot do a commit(). Am i supposed to be doing something in between the stored proc call and the commit?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Stored Procedures and python
November 09, 2007 12:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.