Dynamic stored procedure?

From: Mark Styles <lambic_at_msn.com>
Date: 1996/08/21
Message-ID: <4vf3uq$21d_at_pheidippides.axion.bt.co.uk>#1/1


Can anyone tell me if its possible to call a stored procedure when the name of the procedure is held in a variable?

e.g:

declare

   test varchar2(20) := 'get_emp_salary'; begin

   execute(test);
end;
/

I tried using dbms_sql to do this, but it only recognises standard SQL. Received on Wed Aug 21 1996 - 00:00:00 CEST

Original text of this message