Description
Contact Information
No response
MaxKB Version
v1.10.1-lts (build at 2025-02-13T18:52, commit: 0640d4c)
Problem Description
ALTER PROCEDURE [dbo].[Ai_MaxKb_Python_StockGet_33_lsb]
@PART_NAME VARCHAR ( 200 )='', --产品名称
@warehouse VARCHAR ( 200 )='', --仓库
@BATCH_NO VARCHAR ( 200 )='', --批次/色号
@USER_CODE VARCHAR ( 200 )='',
@message VARCHAR ( 500 )='' OUTPUT
AS BEGIN
-- 库存数据
CREATE TABLE #TempResult (
PART_NAME VARCHAR(100),
WAREHOUSE VARCHAR(100),
SQUARE DECIMAL(18,2),
SORT_ORDER INT
);
INSERT INTO #TempResult (PART_NAME, WAREHOUSE, SQUARE, SORT_ORDER)
SELECT 'A8877AS' AS PART_NAME, '上海' AS WAREHOUSE, 123 AS SQUARE, 1 AS SORT_ORDER;
SELECT * FROM #TempResult;
RETURN
END
Steps to Reproduce
只要函数库的PYTHON里，cursor.execute(f"EXEC Ai_MaxKb_Python_StockGet_33_lsb 'ABC'") 调用执行SQLSERVER的存储过程时，存储过程如上图示例，带有临时表且，注意是且插入临时表数据表就会报错
The expected correct result
No response
Related log output
Additional Information
No response