Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
execute MySql function
#1
Hello,
I have a sql function that returns an integer; I tried the cursor.callproc but ...
    
    def getValue(self, connection):
        cursor = connection.cursor()
        
        cursor.callproc('GetNumber') # [b]here are my doubts; how can I get the returned value ?[/b]
        
many thanks
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Mysql and mysql.connector error lostintime 2 683 Oct-03-2023, 10:25 PM
Last Post: lostintime
  Mysql error message: Lost connection to MySQL server during query tomtom 6 16,092 Feb-09-2022, 09:55 AM
Last Post: ibreeden
  Picking a function to execute palladium 1 1,617 Feb-09-2021, 04:47 PM
Last Post: deanhystad
  How to execute code WHILE a function runs t4keheart 4 2,679 Jan-27-2020, 01:47 PM
Last Post: t4keheart
  Read CSV file into MySQL and use executemany instead of execute bluethundr 1 4,204 May-04-2019, 07:35 AM
Last Post: MvGulik
  Why does my code not execute? (def function with 'for in' iteration over a dictionary Placebo 3 2,929 Oct-19-2018, 01:32 PM
Last Post: Placebo
  execute function at a certain time StevenLewis 0 3,191 Mar-25-2018, 08:41 PM
Last Post: StevenLewis
  argument parser: to execute single function, and subsequent functions also raghu 10 5,880 Mar-12-2018, 06:57 AM
Last Post: wavic

Forum Jump:

User Panel Messages

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