Python Stored Procedure call is not working

[vj78]

Code below does not work ? The mycursor.callproc("getclockinhoursbyweek",()) is the problem.

 mydb = mysqldb.connect(host="localhost", user="xxxxx",password="xxxx", db="xxx", use_unicode=True,charset="utf8")
        mycursor = mydb.cursor()
        mycursor.callproc("getclockinhoursbyweek",())
        myresult = mycursor.fetchall()

I have working code below and it returns data.
The difference in code above is that I am using stored procedure. "getclockinhoursbyweek"

mydb = mysqldb.connect(host="xxxxxx", user="xxxxxx",password="xxxxx", db="xxxxxxx", use_unicode=True,charset="utf8")
mycursor = mydb.cursor()
mycursor.execute("SELECT userid, username, userpassword FROM user")
myresult = mycursor.fetchall()

[buran]

Code below does not work

what does this exactly mean? Do you get any error? What version of MySQL do you use?
Did you check compatibility note:

Compatibility note: It appears that the mere act of executing the CALL statement produces an empty result set, which appears after any result sets which might be generated by the stored procedure. Thus, you will always need to use nextset() to advance result sets.

[vj78]

Code below does not work

what does this exactly mean? Do you get any error? What version of MySQL do you use?
Did you check compatibility note:

Compatibility note: It appears that the mere act of executing the CALL statement produces an empty result set, which appears after any result sets which might be generated by the stored procedure. Thus, you will always need to use nextset() to advance result sets.

Code below does not work ? I am trying to call a stored procedure and that does not work.
Database MariaDB - version 10.4
I think mycursor.callproc("getclockinhoursbyweek",()) is the problem.
Error Message: No result set to fetch from

[vj78]

It works now.

I had to look at this link and change my code:

for result in mycursor.stored_results():
myresult = result.fetchall()

[buran]

Please, don't edit your post AFTER you get a response. This breaks the flow of discussion - now my message seems incorrect after you added some error message. I reverted your latest edits.

[vj78]

Please, don't edit your post AFTER you get a response. This breaks the flow of discussion - now my message seems incorrect after you added some error message. I reverted your latest edits.

Will do.