Python Forum
Python Stored Procedure call is not working
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Python Stored Procedure call is not working
#3
(Apr-04-2021, 07:33 AM)buran Wrote:
(Apr-04-2021, 03:00 AM)vj78 Wrote: 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:
Quote: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
Reply


Messages In This Thread
RE: Python Stored Procedure call is not working - by vj78 - Apr-04-2021, 12:01 PM

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020