Cannot return results from stored procedure using Python cursor

by

Have you tried picking one of the resultsets?

for result in cursor.stored_results():
    people = result.fetchall()

It could be that it’s allocating for multiple resultsets even though you only have one SELECT stmt. I know in PHP’s MySQLi stored procedures do this to allow for INOUT and OUT variable returns (which again, you have none of, but maybe it’s allocating anyways).

The complete code I’m using (which is working) is:

import mysql.connector

cnx = mysql.connector.connect(user="me",password='pw',host="localhost",database="mydb")
cnx._open_connection()
cursor = cnx.cursor()

cursor.callproc("getperson",[1])

for result in cursor.stored_results():
    people=result.fetchall()

for person in people:
    print person

cnx.close()

More Related Contents:

  1. Python read from txt and save into mysql
  2. Lost connection to MySQL server during query
  3. How to install Python MySQLdb module using pip?
  4. Does Python support MySQL prepared statements?
  5. How to convert SQL Query result to PANDAS Data Structure?
  6. How do I get the “id” after INSERT into MySQL database with Python?
  7. Escape string Python for MySQL
  8. How to install MySQLdb (Python data access library to MySQL) on Mac OS X?
  9. pip install mysqlclient returns “fatal error C1083: Cannot open file: ‘mysql.h’: No such file or directory
  10. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  11. Load CSV data into MySQL in Python
  12. Inserting a Python datetime.datetime object into MySQL
  13. MySQL — Joins Between Databases On Different Servers Using Python?
  14. Using a Python dict for a SQL INSERT statement
  15. Python Mysql, “commands out of sync; you can’t run this command now”
  16. Bulk insert with SQLAlchemy ORM
  17. RuntimeError: working outside of application context
  18. Can’t install mysql-python (newer versions) in Windows
  19. Using Django database layer outside of Django?
  20. How to move a model between two Django apps (Django 1.7)
  21. How do i cast char to integer while querying in django ORM?
  22. flake8 complains on boolean comparison “==” in filter clause
  23. What is the best way to access stored procedures in Django’s ORM
  24. How do I get time from a datetime.timedelta object?
  25. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  26. Print results in MySQL format with Python
  27. Python’s MySqlDB not getting updated row
  28. Django + MySQL on Mac OS 10.6.2 Snow Leopard
  29. Single Django model, multiple tables?
  30. flask-login: can’t understand how it works

Leave a Comment