You have to use Dynamic SQL

In 8i:

select procedure_name into v1 from table_name where some condition;

execute immediate 'begin '||v1||'(p1,p2); end;'

In Oracle <8i use DBMS_SQL package.