I would like to pass a colon delimited list to a procedure, set it to a PL/SQL table?? so I can join it to a physical table and process some data.
declare
p_colon_list varchar2(2000):='55:56:147:148:322:325:326:327:328:329:330:331:332:333:334:2901:2902:2903:2904:2905:2906:2907:2908:2909';
begin
??????????????
for x in ( select a.column_value val
from THE ( select cast( l_x as mytableType )
from dual ) a
)
loop
dbms_output.put_line( x.val );
end loop;
???????????????
end;