我遇到了错误,例如:
错误(5,1):请-00103:遇到符号“声明”时,预期如下之一:开始函数、实用化过程、子类型、当前游标删除类型存在于先前的外部语言中,符号" begin“被替换为"DECLARE”以继续。 错误(5,1):请-00103:遇到符号“声明”时,预期如下之一:开始函数、实用化过程、子类型、当前游标删除类型存在于先前的外部语言中,符号" begin“被替换为"DECLARE”以继续。
我的代码是:
CREATE OR REPLACE PROCEDURE procExplicitCursorAccountSlct
AS
DECLARE
CURSOR C1 IS SELECT * FROM ACCOUNT;
BEGIN
OPEN C1;
FOR i in C1 LOOP
FETCH C1 INTO ID,ACCOUNTTYPE,BALANCE;
EXIT WHEN C1%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(ID||'-'||ACCOUNTTYPE||'-'||BALANCE);
DBMS_OUTPUT.PUT_LINE(C1%ROWCOUNT);
END LOOP;
CLOSE C1;
END;发布于 2016-06-27 04:31:25
尝试这一点,并查看内联注释的修改。希望能帮上忙。
CREATE OR REPLACE
PROCEDURE procExplicitCursorAccountSlct
AS
CURSOR C1
IS
SELECT
*
FROM
ACCOUNT;
--Variabke declaration was missing
ID NUMBER;
ACCOUNTTYPE VARCHAR2(100);
BALANCE NUMBER;
--Variabke declaration was missing
BEGIN
OPEN C1;
LOOP
FETCH
C1
INTO
ID,
ACCOUNTTYPE,
BALANCE;
EXIT
WHEN C1%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(ID||'-'||ACCOUNTTYPE||'-'||BALANCE);
DBMS_OUTPUT.PUT_LINE(C1%ROWCOUNT);
END LOOP;
CLOSE C1;
END;发布于 2016-06-27 06:55:29
您可以使用隐式循环(并移除DECLARE )使其变得更加简单:
CREATE OR REPLACE PROCEDURE procExplicitCursorAccountSlct
AS
CURSOR C1 IS SELECT * FROM ACCOUNT;
BEGIN
FOR i in C1 LOOP
DBMS_OUTPUT.PUT_LINE(i.ID||'-'||i.ACCOUNTTYPE||'-'||i.BALANCE);
DBMS_OUTPUT.PUT_LINE(C1%ROWCOUNT);
END LOOP;
END;https://stackoverflow.com/questions/38042799
复制相似问题