Re: Dynamic stored procedure?

Mark Styles wrote:
>
> 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.
I believe dynamic sql will work if you put it in a block declare

begin

   <your procedure here>
end;

as a single string. Then submit the string to the parser. Received on Wed Aug 21 1996 - 00:00:00 CEST