Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL Function Calls

PL/SQL Function Calls

From: Bullseye <none>
Date: Mon, 06 Jun 2005 12:23:39 +0100
Message-ID: <ebc8a11idse3i09vnjsp1v4phvpquevk66@4ax.com>


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)' );

END; TIA Received on Mon Jun 06 2005 - 06:23:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US