Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help: String input to procedure name conversion
this is a job for dbms_sql!
On Fri, 31 Jan 1997 19:21:26 +1100, 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.
>--
>-----------------------------------------------------------------------
>Simon Spencer
>Vice President Work: 203-961-6140
>IPD, Operations and Technology Fax: 203-961-6163
>Emerging Technologies Group Cell:
> Email:sspencer_us_at_hotmail.com
>100 First Stamford Place
>7th Floor, Stamford CT.
>06902 USA
>----------------------------------------------------------------------
Received on Sat Feb 01 1997 - 00:00:00 CST