MySQL Forums
Forum List  »  Connector/Python

Advanced Search
New Topic

Mysql prepared statement in a Store procedura invoked in python through mysql connector
Posted by: Nicolas De saint-aubert
Date: August 02, 2018 03:24PM

I have a sql stored procedure that invokes prepare and execute statements. It Works perfectly when invoked from a mysql workbench editor. But when calling it vía python mysql callproc, it fails with a mysql sintax error exception. It is proved that commenting only the prepare and execute statement in the sql code removes any error when calling from python, Does python mysql conector allow to call a stored procedure that invokes prepared statement?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Mysql prepared statement in a Store procedura invoked in python through mysql connector
Nicolas De saint-aubert
August 02, 2018 03:24PM


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.