Avatar of BILL Carlisle
BILL Carlisle
Flag for United States of America

asked on 

PL/SQL table?

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;
Oracle Database

Avatar of undefined
Last Comment
Sean Stuber

8/22/2022 - Mon