(Apr-04-2021, 07:33 AM)buran Wrote:(Apr-04-2021, 03:00 AM)vj78 Wrote: Code below does not workwhat 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