Error When calling stored procedure in python - Using MySQLdb

Question

I have a MySQL stored procedure called test which accepts one argument. I can execute the stored procedure from python 2.7x using below code

data='Teststr'
cur = db.cursor()
cur.execute("CALL test('{0}')".format(data))

But when I use

data='Teststr'
cur = db.cursor()
cur.callproc('test',data)

I am encountering

OperationalError: (1318, 'Incorrect number of arguments for PROCEDURE MyDb.test; expected 1, got 7')

Looks like python treats each character as one argument. What am I missing here?

Jon Clements · Accepted Answer · 2012-10-23 17:19:26Z

8

You want cur.callproc('test', (data,)) to pass a tuple of 1 element

eg:

>>> a = 'hello'
>>> len(a) # just a
5
>>> len( (a) ) # still just a
5
>>> len( (a,) ) # single element tuple containing a
1

answered Oct 23, 2012 at 16:45

Jon Clements

143k34 gold badges254 silver badges288 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1