There may be ... I just don't know of it if it exists.
But it is very easy to overload a package or to call a single proc that then
distributes the load to other procedures based on the value of a passed
parameter. I don't see it as an issue requiring more than a few lines of code.
> Thanks Daniel, that's what I will check out next...The originals were from
> This way we could add details by calling specific procedures. I thought
> there might be some sort of indirect calling convention but ... oh
> well........... Thanks for your time. Ray C.
> > There may be a way but every attempt I just made returned ORA-00900
> invalid SQL
> > statement. Even an attempt to wrap it in native dynamic SQL.
> > Here's what I would do.
> > 1. Evaluate whether you really need to do it this way (likely you don't)
> > 2. If you do ... look at the feature in packages called overloading which
> > allows you to put many procedures inside of a package with the same name.
> > Daniel Morgan
> > > 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
> > > rather than to pass the param through. I want to be able to call
> > > procedures indirectly depending upon the value of the initial
> > > param value (which contains the exact name of the procedure to call)...
> > > Thanks for your help..Ray
> > > > The same way any procedure passes any parameter to any other
> > > > PROC xyz (param) IS
> > > > BEGIN
> > > > another_proc(param);
> > > > END;
> > > > Daniel Morgan
> > > > > 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.
> > > there
> > > > > a way to use a parameter as a indirect procedure call in the body of
> > > > > 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
> > > > > parameter p_subproc.
> > > > > p_subproc (p_value1);
> > > > > END;
> > > > > Ray Collins