Oracle数据库插入第一条数据后报错，如何解决？


set serveroutput on:
declare
V_SUCC NUMBER(10);
V_TOTAL NUMBER(10);

V_CITY VARCHAR2(16);
V_ADDRESS VARCHAR2(20);

cursor cur_CARDNOTEMP is 
SELECT CITY，ADDRESS FROM USERINFO

begin
    V_SUCC :=0;
    V_TOTAL :=0:
    for C_ROW in cur_CARDNOTEMP loop
    V_CITY := C_ROW.CITY;
    V_ADDRESS := C_ROW.ADDRESS;

    INSERT INTO NewTable (CITY,ADDRESS)
    VALUES (V_CITY,V_ADDRESS)

    V_SUCC := V_SUCC+1;
    V_TOTAL := V_TOTAL+1;

    if V_TOTAL = 100 then
       commit;
       V_TOTAL :=0;
    end if;

    end loop;

    commit;

end;

/

这段代码放Oracle里跑，插入第一条数据之后就报错了，到底是哪里出了问题。。

insert语句后面加（;）作为语句的结束符，试试

img