Re: Indirect Procedure call

I'm sorry, I must not be clear... What I want to do is actually a call totally new procedure using the value "param" as the name of the procedure rather than to pass the param through. I want to be able to call different procedures indirectly depending upon the value of the initial procedure's param value (which contains the exact name of the procedure to call)...

Thanks for your help..Ray

"damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message news:3C752935.B0527E16_at_ci.seattle.wa.us...
> The same way any procedure passes any parameter to any other procedure.
>
> PROC xyz (param) IS
>
> BEGIN
> another_proc(param);
> END;
>
> Daniel Morgan
>
>
>
> "R.A.Collins" wrote:
>
> > Hi, I am new to Oracle and am porting some stored procedures from
another
> > DB. The problem I am having is this - Some of the procedures take in
> > parameters and use those parameters as calls for other procedures. Is
there
> > a way to use a parameter as a indirect procedure call in the body of a
> > procedure??
> >
> > e.g.
> >
> > CREATE PROCEDURE proc1
> > (
> > p_value1 in varchar2,
> > p_subproc in varchar2
> > )
> > as
> > BEGIN
> >
> > p_value1 := 3;
> >
> > -- redirection here such that the routine calls the procedure in the
> > parameter p_subproc.
> > p_subproc (p_value1);
> >
> > END;
> >
> > Ray Collins
>
>
Received on Thu Feb 21 2002 - 13:59:17 CST