run stored procedure in python using pymssql

Question

while executing stored procedure using pymssql getting error:

_mssql.MSSQLDatabaseException: (8144, b'Procedure or function GET_USER_DETAILS has too many arguments specified. DB-Lib error message 8144, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n')

code snippet:

        connection = self.engine.raw_connection()
        cursor = connection.cursor()
        args= ('user')
        cursor.callproc("GET_USER_DETAILS", args)
        cursor.nextset()
        result = list(cursor.fetchone())
        cursor.close()
        connection.commit()
        print(result)

stored procedure GET_USER_DETAILS, accept only one parameter, thats user name.

cursor.callproc("GET_USER_DETAILS", (args,))

Burhan Khalid
– Burhan Khalid

2017-08-17 08:20:09 +00:00
Commented Aug 17, 2017 at 8:20 — Burhan Khalid
– Burhan Khalid, Commented Aug 17, 2017 at 8:20
wow, that worked..@BurhanKhalid

ReshmaA
– ReshmaA

2017-08-17 08:25:22 +00:00
Commented Aug 17, 2017 at 8:25 — ReshmaA
– ReshmaA, Commented Aug 17, 2017 at 8:25

ReshmaA · Accepted Answer · 2017-08-18 03:16:08Z

1

The below code is working.

        connection = self.engine.raw_connection()
        cursor = connection.cursor()
        args= ('user')
        cursor.callproc("GET_USER_DETAILS", (args,))
        cursor.nextset()
        result = list(cursor.fetchone())
        cursor.close()
        connection.commit()
        print(result)

answered Aug 18, 2017 at 3:16

ReshmaA

1051 gold badge3 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

run stored procedure in python using pymssql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related