Missing comma error ,while inserting clob value in table :     CREATE TABLE fcc_consistency_check
    (cons_id         VARCHAR2(30),
    cons_desc       VARCHAR2(4000),
    cons_query      CLOB,
    module_id       VARCHAR2(2),
    main_tab_name   VARCHAR2(30),
    hist_tab_name   VARCHAR2(30),
    col_name        VARCHAR2(4000),
    col_type        VARCHAR2(4000),
    check_reqd      VARCHAR2(1)
    );


    INSERT INTO fcc_consistency_check
    VALUES ('CHK_BC003','Missing records in contract_event_log','select a.CONTRACT_REF_NO ,a.Latest_Event_Seq_No,                                                 
     c.PREV_WORKING_DAY from cstb_contract A ,sttm_dates c
     where module_code = 'BC'
     and c.Branch_code='000'
     and not exists (select * from cstb_contract_event_log B
     where a.contract_ref_no = b.contract_ref_no 
     and latest_event_seq_no = event_seq_no);',
     'BC','BCCC_EVENT_LOG_MISREC','BCCC_EVENT_LOG_MISREC_HISTORY','CONTRACT_REF_NO,LATEST_EVENT_SEQ_NO,EOD_DATE','VARCHAR2(16),NUMBER,DATE','Y');

Not able to insert clob value, getting error missing comma, when i try to insert individual column value then i found that ,error is throwing for column cons_query  .


