for rec in (
            SELECT t.*
                FROM JSON_TABLE(
                    l_clob,'$.items[*]'
                    ERROR ON ERROR
                    COLUMNS(
                        project_ varchar2(800 char) path '$.project[0]',
                        start_date date path '$.start_date',
                        end_date date path '$.end_date',
                        order_xid number path '$.order_xid',
                        xxid number path '$.xxid'
                    )
                ) t
        )loop
            begin
                INSERT INTO IMHO_DYNAMICS (project_id, project_name, startdate, enddate, xxid)
                values (
                (select p.project_id from imho_orders p where p.xid = rec.order_xid), rec.project_, rec.start_date, rec.end_date , rec.xxid
                );
            exception when dup_val_on_index then null;
    --        exception when others then dbms_output.put_line(rec.project_);
            end;
        end loop;

[FIXED]{
            "advertiser": [
                "PROCTER & GAMBLE"
            ],
            "prediction_underspending_impressions_last_day_percent": "24.71929214",
            "prediction_underspending_impressions": 31724,
            "prediction_underspending_impressions_last_day": 31988,
            "impressions_last_day": 3139,
            "impressions_progress": "75.48471852",
            "order_xid": [
                994525
            ],[/FIXED]