declare
v_list varchar2(4000);
begin
begin
v_list := :P4_STATES;
exception when no_data_found then v_list :='0';
end;
for y in (select * from(table(DBMS_UTILITY.comma_to_table(:P4_STATES))))
loop
INSERT INTO COVIDAPI(STATES_NO) values(y.COLUMN_VALUE);
end loop;
for y in (select * from(table(comma_to_table(:P4_POSITIVE))))
loop
insert into COVIDAPI(POSITIVE)
values(y.column_value);
end loop;
for y in (select * from(table(comma_to_table(:P4_NEGATIVE))))
loop
insert into COVIDAPI(NEGATIVE)
values(y.column_value);
end loop;
end;
error:ORA-06550: line 9, column 47: PL/SQL: ORA-00904: : invalid identifier
select * from all_objects where object_name ='COMMA_TO_TABLE'
result: no data found
question: how to install or create the COMMA_TO_TABLE package?
I use apex on cloud, it's not installed in my laptop!