From: N Prabhakar <prabhs@po.pacific.net.sg>
Subject: Re: help: String input to procedure name conversion
Date: 1997/02/02
Message-ID: <5d0mle$7r1$4@newton.pacific.net.sg>#1/1
references: <32F1AB86.6B15@citicorp.com>
to: simon.spencer@citicorp.com
content-type: text/plain; charset=us-ascii
organization: Socgen Crosby Securities
mime-version: 1.0
newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server
x-mailer: Mozilla 1.22KIT (Windows; I; 16bit)



Simon Spencer <simon.spencer@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@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