--------错误提示在这儿---------------
SELECT xmlcontent
-------------------------------------- INTO MDESCRIPT
FROM xmlfilerecord
WHERE xmlcontentid = MDESCRIPT1;ORA-01403: 未找到数据
ORA-06512: 在"SZEMR.OUT_EMR", line 77
ORA-06512: 在line 3View program sources of error stack?
SELECT xmlcontent
-------------------------------------- INTO MDESCRIPT
FROM xmlfilerecord
WHERE xmlcontentid = MDESCRIPT1;ORA-01403: 未找到数据
ORA-06512: 在"SZEMR.OUT_EMR", line 77
ORA-06512: 在line 3View program sources of error stack?
SELECT xmlcontent
INTO MDESCRIPT
FROM xmlfilerecord
WHERE xmlcontentid = MDESCRIPT1;
EXCEPTION
-- 杤桳悢悩
WHEN NO_DATA_FOUND THEN
NULL;
-- 2忦埲忋
WHEN TOO_MANY_ROWS THEN
NULL;
END;
SELECT xmlcontent
INTO MDESCRIPT
FROM xmlfilerecord
WHERE xmlcontentid = MDESCRIPT1;
EXCEPTION
-- 没有数据
WHEN NO_DATA_FOUND THEN
NULL;
-- 2条数据
WHEN TOO_MANY_ROWS THEN
NULL;
END;