Re: help: String input to procedure name conversion

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1997/02/02
Message-ID: <5d0mle$7r1$4@newton.pacific.net.sg>#1/1

Simon Spencer <simon.spencer_at_citicorp.com> wrote:
>I am asking this for someone else, but am interested in the answer
>myself.
>
>How do i take a string value within a pl/sql proceedure and convert that
>to a proceedure?
>
>I have a varchar2 with the name of the procedure i want to call and
>somehow i want to execute that procedure.
>
>ie app_name varchar2
>
> app_name := "my_procedure"
>
> app_name;
>
>How can I do this or get the same effect.
>
>If you can copy mmansour_at_hotmail.com as well as me, that is sure
>appreciated.
>
>Simon.

Hi there,

You can use DBMS_SQL to execute an stored procedure. Form the sql statement dynamically and fire it using DBMS_SQL.execute statement. This feature is available from Oracle 7.2.x

Regards

N.Prabhakar Received on Sun Feb 02 1997 - 00:00:00 CST