我在form中写produce,定义cursor c_qty is select column1,column2,column3------from view ,执行时系统报错,ora-01001,而当我重新定义cursor is c_qty is select column1,column2 from view时,运行正常。这到底是怎么回事,前一天运行还好,请高手帮忙。
可以呀。9.2.0.5.0
declare
cursor cur is select empno,ename,deptno,sal from scott.emp;
v_empno number;
v_ename varchar2(10);
v_deptno number;
v_sal number;
begin
opencur;
loop
exit when cur%notfound;
fetch cur into v_empno,v_ename,v_deptno,v_sal;
dbms_output.put_line(v_empno||' '||v_ename||' '||v_deptno||' '||v_sal);
end loop;
close cur;
end ;
/
7369 SMITH 20 800
7499 ALLEN 30 1600
7521 WARD 30 1250
7566 JONES 20 2975
7654 MARTIN 30 1250
7698 BLAKE 30 2850
7782 CLARK 10 2450
7788 SCOTT 20 3000
7839 KING 10 5000
7844 TURNER 30 1500
7876 ADAMS 20 1100
7900 JAMES 30 950
7902 FORD 20 3000
7934 MILLER 10 1300
7934 MILLER 10 1300
PL/SQL procedure successfully completed