Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!area.cu.mi.it!news.mailgate.org!draco.tiscalinet.it!news-f1.tiscali.it!not-for-mail
Date: Mon, 06 Jun 2005 13:35:15 +0200
From: Cris Carampa <cris119@operamail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040114
X-Accept-Language: it, en-us
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: PL/SQL Function Calls
References: <ebc8a11idse3i09vnjsp1v4phvpquevk66@4ax.com>
In-Reply-To: <ebc8a11idse3i09vnjsp1v4phvpquevk66@4ax.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 27
Message-ID: <42a4350a$0$17096$5fc30a8@news.tiscali.it>
Organization: Tiscali SpA
NNTP-Posting-Host: 212.22.134.85
X-Trace: 1118057739 news.tiscali.it 17096 212.22.134.85:35053
X-Complaints-To: abuse@tiscali.it
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244314

Bullseye wrote:

> PROCEDURE test (ProcName) IS
> BEGIN
>    DECLARE
> 
>    BEGIN
>     << do something>>
> 
>     < Execute Procedure 'ProcName' as passed in Arguments >>;

execute immediate 'begin '||ProcName||'; end;' ;

> 
>     << do something else
>    END;
> END;

Kind regards,

-- 
Cris Carampa (cris119@operamail.com)
"E` evidente che siamo di fronte allo sfruttamento opportunistico
  di quella quota di astensioni fatalmente derivanti da disinteresse
  o indifferenza." (Gustavo Zagrebelsky)