为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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
想请教这个存储过程有什么问题
CREATE OR REPLACE PROCEDURE "USP_Ass_SelectLinkInfo"
(
$LinkID VARCHAR(500),
$ProbeID VARCHAR(500)
)
AS
DM_sqlcond VARCHAR(1000) DEFAULT ' where 1=1';
DM_sqlcmd VARCHAR(4000);
BEGIN
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;
有具体的报错提示么