Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table disp_data(id number, data varchar2(4000));


Insert into disp_data(id,data) values(100,
'["Project title as per the outstanding Requirements","The values are,\n not with respect to the requirement and analysis done by the team. 
Also it is difficult to, prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex\n however it is up to the team","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","","","","","25"]');
1 rows affected

Insert into disp_data(id,data) values(110,
'["Project title afor BYU heads","The values are\n, exactly up to the requirement and analysis done by the team. 
Also it is difficult to, prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex however it is up to the team","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","Apprehension","","","","25","Stable"]');
1 rows affected

create table PUSH_DATA_TEMP
(
id_pk NUMBER,
  id    NUMBER,
  col1  VARCHAR2(4000),
  col2  VARCHAR2(4000),
  col3  VARCHAR2(4000),
  col4  VARCHAR2(4000),
  col5  VARCHAR2(4000),
  col6  VARCHAR2(4000),
  col7  VARCHAR2(4000),
  col8  VARCHAR2(4000),
  col9  VARCHAR2(4000),
  col10 VARCHAR2(4000),
  col11 VARCHAR2(4000),
  col12 VARCHAR2(4000),
   col13 VARCHAR2(4000),
    col14 VARCHAR2(4000)
);
create sequence push_Seq 
minvalue 1
maxvalue 999999999999999999
increment by 1 
start with 1
cache 20
noorder
nocycle;
CREATE OR REPLACE TRIGGER PUSH_TRIGGER 
BEFORE INSERT ON PUSH_DATA_TEMP 
REFERENCING FOR EACH ROW
BEGIN
  IF :NEW.ID_PK IS NULL THEN
   select push_seq.nextval 
     into :NEW.ID_PK from dual;
  end if;
end;
/
CREATE OR REPLACE PROCEDURE PUSH_DATA(p_id NUMBER,data_string varchar2) IS
  CURSOR cur_data IS
    WITH input
    AS
    (select data_string from dual),
    rcte (id, data, lvl, result)
    AS (
         SELECT p_id, data, 1,regexp_substr(data,
                '(".*?")(,|\])', 1, 1, 'n', 1) result
           FROM (select data_string data from input) 
        UNION ALL
         SELECT id, data, lvl + 1,
                regexp_substr(data, '(".*?")(,|\])', 1, lvl + 1, 'n', 1)
           FROM rcte
        WHERE lvl <= regexp_count(data, '(".*?")(,|\])',1,'n')
       )
    SELECT *
    FROM (SELECT id, lvl, replace(result,'""','') as result
            FROM rcte)
    PIVOT (MAX(result)
     FOR (lvl) IN(1 AS col1
                  ,2 AS col2
                  ,3 AS col3
                  ,4 AS col4
                  ,5 AS col5
                  ,6 AS col6
                  ,7 AS col7
                  ,8 AS col8
                  ,9 AS col9
                  ,10 AS col10
                  ,11 AS col11
                  ,12 AS col12
                     ,13 AS col13
                        ,14 AS col14));
   var cur_data%ROWTYPE;
BEGIN
  OPEN cur_data;
  LOOP
    FETCH cur_data INTO var;
    EXIT WHEN cur_data%NOTFOUND;
    UPDATE push_data_temp
    SET col1 = var.col1
      , col2 = var.col2
      , col3 = var.col3
      , col4 = var.col4
      , col5 = var.col5
      , col6 = var.col6
      , col7 = var.col7
      , col8 = var.col8
      , col9 = var.col9
      , col10 = var.col10
      , col11 = var.col11
      , col12 = var.col12
      , col13 = var.col13
      , col14 = var.col14
    WHERE ID = var.id;
    IF SQL%ROWCOUNT = 0
    THEN
       INSERT INTO push_data_temp(id, col1, col2, col3, col4, col5,
                                  col6, col7, col8, col9, col10, col11, col12,col13,col14)
          VALUES (var.id, var.col1, replace(var.col2,'\n',chr(10)),replace(var.col3,'\n',chr(10)),var.col4,var.col5,
                  var.col6,var.col7,var.col8,var.col9,var.col10,var.col11,var.col12,var.col13,var.col14);
    END IF;
  END LOOP;
END;
/
declare 
   v_test_proc varchar2(50) :='push_data'; 
   v_sql varchar2(2000);
   --
   v_p_id number;
   v_string varchar2(4000); -- this can be removed
   v_final_string varchar2(4000);
   --
begin
  --
  v_p_id := 110;
  v_string := '["Project title afor BYU heads","The values are,\n exactly up to the requirement and analysis done by the team.
                 Also it is difficult to,\n prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex however it is up to the team","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","Apprehension","","","","25","Stable"]';
  --
  --don't much but trying to repalce anything matches with '[' or ']'
  v_final_string :=  v_string;
  --
  v_sql :=  'begin '||
              v_test_proc||'(:pid,:data);'||
            'end;'; 
  execute immediate v_sql using v_p_id,v_final_string; 
end;
/
1 rows affected

SELECT * FROM push_data_temp;


ID_PK
ID
COL1
COL2
COL3
COL4
COL5
COL6
COL7
COL8
COL9
COL10
COL11
COL12
COL13
COL14


1
110
"Project title afor BYU heads"
"The values are,
 exactly up to the requirement and analysis done by the team.
                 Also it is difficult to,
 prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex however it is up to the team"
"Active"
"Disabled"
"25 tonnes of fuel"
"www.examplesites.com/html.asp&net;"
"Apprehension"
null
null
null
"25"
"Stable"
null
null


BEGIN
PUSH_DATA(110,'["Project title afor BYU heads","The values are,\n exactly up to the requirement and analysis done by the team.
Also it is difficult to,\n prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex however it is up to the team","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","Apprehension","","","","25","Stable"]');
END;
/
1 rows affected

select * from push_data_temp;


ID_PK
ID
COL1
COL2
COL3
COL4
COL5
COL6
COL7
COL8
COL9
COL10
COL11
COL12
COL13
COL14


1
110
"Project title afor BYU heads"
"The values are,\n exactly up to the requirement and analysis done by the team.
Also it is difficult to,\n prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex however it is up to the team"
"Active"
"Disabled"
"25 tonnes of fuel"
"www.examplesites.com/html.asp&net;"
"Apprehension"
null
null
null
"25"
"Stable"
null
null


BEGIN
PUSH_DATA(110,'[""Project title afor BYU heads"","The values are,\n "exactly" up to the requirement and analysis done by the team.
Also it is difficult to,\n prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex however it is up to the team","Active","Disabled","25 tonnes of fuel","www.examplesites.com/html.asp&net;","Apprehension","","","","25","Stable"]');
END;
/
1 rows affected

SELECT * FROM push_data_temp;


ID_PK
ID
COL1
COL2
COL3
COL4
COL5
COL6
COL7
COL8
COL9
COL10
COL11
COL12
COL13
COL14


1
110
Project title afor BYU heads
"The values are,\n "exactly" up to the requirement and analysis done by the team.
Also it is difficult to,\n prepare a scenario notwithstanding the fact it is difficult. This user story is going to be slightly complex however it is up to the team"
"Active"
"Disabled"
"25 tonnes of fuel"
"www.examplesites.com/html.asp&net;"
"Apprehension"
null
null
null
"25"
"Stable"
null
null