提示:missing VALUES keyword

Question

添加语句(SQLWindow):
 insert into t_non_recurring_charge_xjs CHARGE_ID,CHARGE_DESCRIPTION,CHARGE_LEVEL_CODE,ACTIVE_DATE,INACTIVE_DATE,IS_ARREAR, PROD_ID,CHARGE_NAME,CHARGE_CAT_ID,STATUS 
values(col1,col2,notcode,col3,col4,notcode,'',col2,col11,notcode);过程代码:
create or replace procedure mygc is notcode number;--新增加的字段
sql_stmt  varchar2(1000);--用来存取sql
col1 number;--SO_CHARGE_TYPE_ID
col2 varchar2(50);--SO_CHARGE_NAME
col3 date;--EFF_DATE
col4 date;--EXP_DATE
col11 number;--CHARFE_CAT_IDcursor cur is select SO_CHARGE_TYPE_ID,SO_CHARGE_NAME,EFF_DATE,EXP_DATE from SO_CHARGE_TYPE@db_dqyy;
cursor cur1 is select CHARGE_CAT_ID from T_CHARGE_CATEGORY;
--cursor cur1 is select * from CHARGE_CAT_ID  from T_CHARGE_CATEGORY;
begin
 --sql_stmt :=' select CHARGE_CAT_ID  from T_CHARGE_CATEGORY';
  
  notcode := 0;
 
  open cur;       fetch cur into col1,col2,col3,col4;
       while cur%found loop
       
              open cur1;
              fetch cur1 into col11;
                while cur1%found loop
--提示的就是下面insert语句缺失 values 关键字，但我确实写上了 
                insert into t_non_recurring_charge_xjs  
                CHARGE_ID,CHARGE_DESCRIPTION,CHARGE_LEVEL_CODE,ACTIVE_DATE,INACTIVE_DATE,IS_ARREAR, PROD_ID,CHARGE_NAME,CHARGE_CAT_ID,STATUS
                values(col1,col2,notcode,col3,col4,notcode,'',col2,col11,notcode);
 
                fetch cur1 into col11;
             end loop;
             close cur1;
       fetch cur into col1,col2,col3,col4;
  end loop;
  close cur;
end mygc;
麻烦高手给解答下 谢谢!

Answer 1

insert into t_non_recurring_charge_xjs(               CHARGE_ID,CHARGE_DESCRIPTION,CHARGE_LEVEL_CODE,ACTIVE_DATE,INACTIVE_DATE,IS_ARREAR, PROD_ID,CHARGE_NAME,CHARGE_CAT_ID,STATUS) 
                values(col1,col2,notcode,col3,col4,notcode,'',col2,col11,notcode); 

Answer 2

insert into t_non_recurring_charge_xjs  
(               CHARGE_ID,CHARGE_DESCRIPTION,CHARGE_LEVEL_CODE,ACTIVE_DATE,INACTIVE_DATE,IS_ARREAR, PROD_ID,CHARGE_NAME,CHARGE_CAT_ID,STATUS
)