Re: Indirect Procedure call

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.

Daniel Morgan

"R.A.Collins" wrote:

> Thanks Daniel, that's what I will check out next...The originals were from
> MS Sql Server and went something like "execute @state_proc ...params... ".
> 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.
>
> "damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
> news:3C756583.FC929135_at_ci.seattle.wa.us...
> > 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
> >
> >
> >
> >
> > Ray C wrote:
> >
> > > 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 - 16:44:33 CST