Re: Indirect Procedure call

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 21 Feb 2002 17:06:40 GMT
Message-ID: <3C752935.B0527E16@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 - 11:06:40 CST