troubleshooting Question

PL/SQL table?

Avatar of BILL Carlisle
BILL CarlisleFlag for United States of America asked on
Oracle Database
9 Comments3 Solutions450 ViewsLast Modified:
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;
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros