执行插入存储过程运行报错,报错如下:
哪位大师解答一下啊,如何获取到select 后的 这一部分
declare @RespCode varchar(10); declare @RespMessage varchar(100); declare @OrderId varchar(20);declare @SqNo varchar(3);
exec zsyy_LockOrder '8072','1086','0000221424','4201241972','1','2023-07-28','08:00:00','111111','PBB00000012795010','1','1','1',@RespCode output,@RespMessage output,@OrderId output,
@SqNo output;select @RespCode as RespCode, @RespMessage as RespMessage,@orderId as orderId,
@SqNo as SqNo
No results. Previous SQL was not a query.
Traceback (most recent call last):
File "D:\Python\Python36\lib\site-packages\spyne\application.py", line 173, in process_request
ctx.out_object = self.call_wrapper(ctx)
File "D:\Python\Python36\lib\site-packages\spyne\application.py", line 242, in call_wrapper
return ctx.descriptor.service_class.call_wrapper(ctx)
File "D:\Python\Python36\lib\site-packages\spyne\service.py", line 194, in call_wrapper
return ctx.function(*args)
File "E:\python\app.py", line 552, in LockOrder
str_xml_gxhc = insert_data(str_sql)
File "E:\python\db_odbc.py", line 69, in insert_data
rows = cursor.execute(str_select).fetchone()
pyodbc.ProgrammingError: No results. Previous SQL was not a query.
192.168.000.50 - - [31/Jul/2023 09:01:52] "POST /yygh/ HTTP/1.1" 500 313