SQL> desc test4 名称 是否为空? 类型 ----------------------------------------- -------- ------------ ID NUMBER COST NUMBER NAME VARCHAR2(10) MAX NUMBER ================================================================ CREATE OR REPLACE PROCEDURE forcursor AS CURSOR cur IS SELECT * FROM TEST4; BEGIN FOR c IN cur LOOP dbms_output.put_line(c.MAX); END LOOP; END; / 这样用没问题,不知道你的什么情况
名称 是否为空? 类型
----------------------------------------- -------- ------------ ID NUMBER
COST NUMBER
NAME VARCHAR2(10)
MAX NUMBER
================================================================
CREATE OR REPLACE PROCEDURE forcursor
AS
CURSOR cur IS SELECT * FROM TEST4;
BEGIN
FOR c IN cur LOOP
dbms_output.put_line(c.MAX);
END LOOP;
END;
/
这样用没问题,不知道你的什么情况