DECLARE --V_XM VARCHAR2(10); V_XM KS.XM%TYPE; --V_MM VARCHAR2(10); V_MM KS.MM%TYPE; CURSOR C_KS IS SELECT XM, MM FROM KS; BEGIN OPEN C_KS; LOOP
FETCH C_KS INTO V_XM, V_MM;
EXIT WHEN C_KS%NOTFOUND;
END LOOP; CLOSE C_KS; END
DECLARE --V_XM VARCHAR2(10); V_XM KS.XM%TYPE; --V_MM VARCHAR2(10); V_MM KS.MM%TYPE; CURSOR C_KS IS SELECT XM, MM FROM KS; BEGIN OPEN C_KS; LOOP
FETCH C_KS INTO V_XM, V_MM;
EXIT WHEN C_KS%NOTFOUND;
END LOOP; CLOSE C_KS; END ;
DECLARE V_XM KS.XM%TYPE; V_MM KS.MM%TYPE; CURSOR C_KS IS SELECT XM, MM FROM KS; BEGIN OPEN C_KS; LOOP FETCH C_KS INTO V_XM, V_MM; EXIT WHEN C_KS%NOTFOUND; END LOOP; CLOSE C_KS; END ;
v_XM varchar2(2000);
v_MM varchar2(2000);
变量定义
begin
需要处理的语录
end;
变量定义的长度要比实际数据长度大
--V_XM VARCHAR2(10);
V_XM KS.XM%TYPE;
--V_MM VARCHAR2(10);
V_MM KS.MM%TYPE; CURSOR C_KS IS
SELECT XM, MM FROM KS;
BEGIN OPEN C_KS;
LOOP
FETCH C_KS
INTO V_XM, V_MM;
EXIT WHEN C_KS%NOTFOUND;
END LOOP; CLOSE C_KS;
END
--V_XM VARCHAR2(10);
V_XM KS.XM%TYPE;
--V_MM VARCHAR2(10);
V_MM KS.MM%TYPE; CURSOR C_KS IS
SELECT XM, MM FROM KS;
BEGIN OPEN C_KS;
LOOP
FETCH C_KS
INTO V_XM, V_MM;
EXIT WHEN C_KS%NOTFOUND;
END LOOP; CLOSE C_KS;
END ;
V_MM KS.MM%TYPE;
CURSOR C_KS IS
SELECT XM, MM FROM KS;
BEGIN
OPEN C_KS;
LOOP
FETCH C_KS
INTO V_XM, V_MM;
EXIT WHEN C_KS%NOTFOUND;
END LOOP;
CLOSE C_KS;
END ;
第二:v_XM varchar2(10);v_MM varchar2(10);这连个参数定义的不好,可能长度不够