Python Forum
How to capture the result set from a stored procedure?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to capture the result set from a stored procedure?
#3
Thanks deanhystad,

Those are SQL code. How do I get the dataset in Python? Your example is returning a single value in SQL or Python? It seems in SQL.

I tried the link you provided for the Examples of returning data using a result set. I added RETURN at the end of the stored procedure, but I got the same message "No results. Previous SQL was not a query."

In Python, I just use dateset = the SQL return value (or dataset)?

Thanks again.
Dee
Reply


Messages In This Thread
RE: How to capture the result set from a stored procedure? - by dee - May-24-2024, 05:00 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  python script is hanging while calling a procedure in database prasanthi417 4 777 Jan-17-2024, 02:33 PM
Last Post: deanhystad
  python call stored procedure mg24 2 1,200 Oct-18-2022, 02:19 AM
Last Post: mg24
  python call stored procedure with two parameter mg24 4 1,839 Sep-27-2022, 05:02 AM
Last Post: deanhystad
  capture print statement written in Stored Procedure in SQL Server brijeshkumar_77 0 2,683 Feb-18-2020, 03:22 AM
Last Post: brijeshkumar_77
  Execute SQL Server Stored Procedure brijeshkumar_77 0 3,233 Feb-18-2020, 02:59 AM
Last Post: brijeshkumar_77
  What do you think of this procedure to create a path to a folder atlass218 10 6,747 Sep-06-2019, 07:53 AM
Last Post: atlass218
  How to return value from a stored procedure of a MySQL database? UtiliseIT 0 2,420 Jul-22-2019, 10:14 AM
Last Post: UtiliseIT
  Add a stored procedure with variable using MySQL Connector UtiliseIT 0 2,361 May-04-2019, 12:46 PM
Last Post: UtiliseIT
  Unable to use sqlanydb to execute Sybase IQ Stored Procedure FORTITUDE 4 3,944 Sep-15-2018, 05:03 PM
Last Post: FORTITUDE
  Procedure Not Executing jge047 1 2,809 Dec-01-2017, 07:00 AM
Last Post: buran

Forum Jump:

User Panel Messages

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