SQL> ed
Wrote file afiedt.buf

  1  create or replace procedure
  2  test1
  3  as
  4  begin
  5  dbms_output.put_line('user1 is callin test1!');
  6* end;
SQL> /

Procedure created.

SQL> ed
Wrote file afiedt.buf

  1  create or replace procedure
  2  test2
  3  as
  4  begin
  5  dbms_output.put_line('user2 is callin test2!');
  6* end;
SQL> /

Procedure created.

SQL> select * from userneed;

        ID NEED
---------- ------------------------------
         1 test1
         2 test2

SQL> create or replace procedure userneed_sp
  2  (pid in number)
  3  as
  4  cursor c1 is select need from userneed where id=pid;
  5  begin
  6  for mag in c1 loop
  7  execute immediate ('begin '||mag.need||'; end;');
  8    end loop;
  9  end;
 10  /

Procedure created.

SQL> exec userneed_sp(1);
user1 is callin test1!

PL/SQL procedure successfully completed.

SQL>  exec userneed_sp(2);
user2 is callin test2!

PL/SQL procedure successfully completed.