declare
   v_proc varchar2(30);
begin
   v_proc := :control.proc;   
   if v_proc = 'SP1' then
      SP1;      
   elsif v_proc = 'SP2' then
      SP2;
   end if;
end;

declare
   v_proc varchar2(30);
begin
   v_proc := :control.proc;   
   call name_in(v_proc);  -- assuming dynamic call 
end;

CREATE OR REPLACE PROCEDURE exec_Dynamic_Proc_sp
     (Proc_Name  IN VARCHAR2)
IS
BEGIN
  IF Proc_Name IS NOT NULL  THEN
    EXECUTE IMMEDIATE ('Exec '||Proc_Name);
  END IF;
    
EXCEPTION 
  /* write exceptions according to your nead. Like is passed procedure
   does not exists or user do not have access to execute that procedure.
   you can also check the existence of procedure before execute 
   immediate by checking in object table.*/
WHEN OTHERS 
  null;
END;

begin
  Exec_Dynamic_proc_sp(:control.proc); 
end;

declare
  v_code varchar2(30);
cursor c1 (p1 varchar2) is
select code
  from tbl_dyn_sp
 where code = p1;
begin
   open c1(<variable>);
   fetch c1 into v_code;
   close c1;

   -- here is my question --
   -- how would I call the Program unit 
   -- depends on the variable passed?
   
   call v_code;  -- any other way to invoke the Program units?

   --
end;