python call stored procedure with two parameter

Thread Rating:

Thread Modes

python call stored procedure with two parameter

mg24
Lumberjack

Posts: 119

Threads: 66

Joined: Sep 2022

Reputation: 0

Sep-26-2022, 07:45 PM

Hi Team,

I found a solution with some troubleshooting , code started working.

params = ('ABC_Company','Employee")
sql = "Exec unique_query ?,?"


cursor.execute(sql,params)
data = cursor.fetchall()

print(data)

Find

Messages In This Thread

RE: python call stored procedure with two parameter - by mg24 - Sep-26-2022, 07:45 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	How to capture the result set from a stored procedure?	dee	5	4,943	May-25-2024, 01:03 AM Last Post: deanhystad
	python script is hanging while calling a procedure in database	prasanthi417	4	2,226	Jan-17-2024, 02:33 PM Last Post: deanhystad
	How do I handle escape character in parameter arguments in Python?	JKR	6	6,070	Sep-12-2023, 03:00 AM Last Post: Apoed2023
	[ERROR] ParamValidationError: Parameter validation failed: Invalid type for parameter	gdbengo	3	18,015	Dec-26-2022, 08:48 AM Last Post: ibreeden
	python call stored procedure	mg24	2	2,224	Oct-18-2022, 02:19 AM Last Post: mg24
	I need my compiled Python Mac app to accept a file as a parameter	Oethen	2	3,462	May-10-2020, 05:57 PM Last Post: Oethen
	capture print statement written in Stored Procedure in SQL Server	brijeshkumar_77	0	3,357	Feb-18-2020, 03:22 AM Last Post: brijeshkumar_77
	Execute SQL Server Stored Procedure	brijeshkumar_77	0	4,900	Feb-18-2020, 02:59 AM Last Post: brijeshkumar_77
	what would you call the input for the parameter(s) of a function you have defined?	rix	3	3,449	Dec-16-2019, 12:04 AM Last Post: rix
	Python Parameter inside Json file treated as String	dhiliptcs	0	2,548	Dec-10-2019, 07:28 PM Last Post: dhiliptcs

Users browsing this thread: 1 Guest(s)