注册

从mysql迁移存储过程过来,存储过程执行报错问题

CZhui 2024/08/22 449 3

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:CREATE OR REPLACE PROCEDURE "tistone_flow"."USP_Ass_SelectLinkInfo"
(
$LinkID VARCHAR(500),
$ProbeID VARCHAR(500)
) AS
BEGIN
DECLARE DM_sqlcond VARCHAR(1000) DEFAULT ' where 1=1';
DECLARE DM_sqlcmd VARCHAR(4000);
IF $LinkID <> '' THEN
SET DM_sqlcond = CONCAT(DM_sqlcond,' and LinkID in (',$LinkID,')');
END IF;
IF $ProbeID <> '' THEN
SET DM_sqlcond = CONCAT(DM_sqlcond,' and ProbeID in (',$ProbeID,')');
END IF;
SET DM_sqlcmd = CONCAT('SELECT LinkID,
LinkName,
LinkType,
BandwidthIn,
BandwidthOut,
InnerPoint,
InnerPointName,
OuterPoint,
OuterPointName,
ProbeID,
ProbeName,
Period,
ProbeCardIF,
CardMode,
ContactPerson,
ContactEmail,
ContactTelphone,
"" BeginCoordInfo,
"" EndCoordInfo
FROM tbl_ass_linkinfo',DM_sqlcond);

EXECUTE IMMEDIATE DM_sqlcmd
;
END

想请教这个存储过程有什么问题

回答 0
暂无回答
扫一扫
联系客服