Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL Function Calls
HI
from within a PL/SQL procedure, is it possible to call another procedure whose name is passed in as an argument (IE not known until run time).
For example:-
PROCEDURE test (ProcName) IS
BEGIN
DECLARE
BEGIN
<< do something>>
< Execute Procedure 'ProcName' as passed in Arguments >>;
<< do something else
END;
END;
Example of Calling Procedure:-
BEGIN
test( 'UserProc1(Param)' ); test( 'UserProc2(Param)' ); test( 'UserProc3(Param)' );