Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!transit.news.xs4all.nl!195.129.110.179.MISMATCH!bnewsoutpeer01.bru.ops.eu.uu.net!lnewsinpeer00.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
From: Bullseye <none>
Newsgroups: comp.databases.oracle.server
Subject: PL/SQL Function Calls
Date: Mon, 06 Jun 2005 12:23:39 +0100
Message-ID: <ebc8a11idse3i09vnjsp1v4phvpquevk66@4ax.com>
X-Newsreader: Forte Free Agent 2.0/32.652
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 31
Organization: Pipex
NNTP-Posting-Host: 81-178-34-25.dsl.pipex.com
X-Trace: 1118057081 news.dial.pipex.com 361 81.178.34.25:32280
X-Complaints-To: abuse@uk.uu.net
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244311

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