create or replace procedure linquiryfeerate01() is declare
cursor c is select inquiryno, inquiryversion,factorlno, salechnl from linquiryfeerate_temp;
emprow linquiryfeerate_temp%rowtype ; --定义行类型begin
open c;
loop fetch c into emprow;
exit when c%notfound;
insert into linquiryfeerate ( inquiryno, inquiryversion,factorlno, salechnl)
values (emprow.inquiryno , emprow.inquiryversion ,emprow.factorlno ,emprow.salechnl);
dbms_output.put_line(emprow.inquiryno || '---' || emprow.inquiryversion || '---'||emprow.factorlno || '---' ||emprow.salechnl );
end loop;
close c;end linquiryfeerate01;报错 信息:Error: PLS-00103: 出现符号 ")"在需要下列之一时:
<an identifier>
<a double-quoted delimited-identifier> current
Line: 1
Text: create or replace procedure linquiryfeerate01() is求高手帮忙指点下
cursor c is select inquiryno, inquiryversion,factorlno, salechnl from linquiryfeerate_temp;
emprow linquiryfeerate_temp%rowtype ; --定义行类型begin
open c;
loop fetch c into emprow;
exit when c%notfound;
insert into linquiryfeerate ( inquiryno, inquiryversion,factorlno, salechnl)
values (emprow.inquiryno , emprow.inquiryversion ,emprow.factorlno ,emprow.salechnl);
dbms_output.put_line(emprow.inquiryno || '---' || emprow.inquiryversion || '---'||emprow.factorlno || '---' ||emprow.salechnl );
end loop;
close c;end linquiryfeerate01;报错 信息:Error: PLS-00103: 出现符号 ")"在需要下列之一时:
<an identifier>
<a double-quoted delimited-identifier> current
Line: 1
Text: create or replace procedure linquiryfeerate01() is求高手帮忙指点下
cursor c is select inquiryno, inquiryversion,factorlno, salechnl from linquiryfeerate_temp;
emprow linquiryfeerate_temp%rowtype ; --定义行类型begin
open c;
loop fetch c into emprow;
exit when c%notfound;
insert into linquiryfeerate ( inquiryno, inquiryversion,factorlno, salechnl)
values (emprow.inquiryno , emprow.inquiryversion ,emprow.factorlno ,emprow.salechnl);
dbms_output.put_line(emprow.inquiryno || '---' || emprow.inquiryversion || '---'||emprow.factorlno || '---' ||emprow.salechnl );
end loop;
close c;end linquiryfeerate01;
cursor c is select inquiryno, inquiryversion,factorlno, salechnl from linquiryfeerate_temp;
emprow linquiryfeerate_temp%rowtype ; --定义行类型begin
open c;
loop fetch c into emprow;
exit when c%notfound;
insert into linquiryfeerate ( inquiryno, inquiryversion,factorlno, salechnl)
values (emprow.inquiryno , emprow.inquiryversion ,emprow.factorlno ,emprow.salechnl);
dbms_output.put_line(emprow.inquiryno || '---' || emprow.inquiryversion || '---'||emprow.factorlno || '---' ||emprow.salechnl );
end loop;
close c;end linquiryfeerate01;
这个写法出现以下错误Compilation errors for PROCEDURE LIS.LINQUIRYFEERATE01Error: PLS-00394: wrong number of values in the INTO list of a FETCH statement
CURSOR C IS
SELECT INQUIRYNO, INQUIRYVERSION, FACTORLNO, SALECHNL
FROM LINQUIRYFEERATE_TEMP;
EMPROW LINQUIRYFEERATE_TEMP%ROWTYPE; --定义行类型BEGIN OPEN C; LOOP
FETCH C
INTO EMPROW;
EXIT WHEN C%NOTFOUND;
INSERT INTO LINQUIRYFEERATE
(INQUIRYNO, INQUIRYVERSION, FACTORLNO, SALECHNL)
VALUES
(EMPROW.INQUIRYNO,
EMPROW.INQUIRYVERSION,
EMPROW.FACTORLNO,
EMPROW.SALECHNL);
DBMS_OUTPUT.PUT_LINE(EMPROW.INQUIRYNO || '---' ||
EMPROW.INQUIRYVERSION || '---' ||
EMPROW.FACTORLNO || '---' || EMPROW.SALECHNL);
END LOOP; CLOSE C;