Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g49g2000cwa.googlegroups.com!not-for-mail
From: "Chris ( Val )" <chrisval@bigpond.com.au>
Newsgroups: comp.databases.oracle.server
Subject: Re: PL/SQL Function Calls
Date: 6 Jun 2005 17:12:51 -0700
Organization: http://groups.google.com
Lines: 26
Message-ID: <1118103171.117619.292440@g49g2000cwa.googlegroups.com>
References: <ebc8a11idse3i09vnjsp1v4phvpquevk66@4ax.com>
   <42a4350a$0$17096$5fc30a8@news.tiscali.it>
   <21f8a1dd60updc2vihnq27uv3mbnu4ft42@4ax.com>
   <usXoe.4354$F7.4231@news-server.bigpond.net.au>
   <1118062279.769559.41020@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: 203.89.239.218
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1118103176 30981 127.0.0.1 (7 Jun 2005 00:12:56 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 7 Jun 2005 00:12:56 +0000 (UTC)
In-Reply-To: <1118062279.769559.41020@o13g2000cwo.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g49g2000cwa.googlegroups.com; posting-host=203.89.239.218;
   posting-account=NN6ARQwAAACSjczBRtLvdcoDYZmZzbx0
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244399



Billy wrote:
> Chris ( Val ) wrote:
>
> > Well, if "ProcName" is a varchar2 type for example,
> > then it only makes sense to use the following call:
> >
> > exec test( 'Procedure(''Argument'')' );
>
> EXEC command is a SQL*Plus macro command and not a valid SQL or PL/SQL
> command.

Sorry - I thought the OP wanted to know how to execute
the procedure from within an SQL*PLUS session.

> Using literals and not bind variables is a great way to stuff up
> performance, cause shared pool fragmentation and generally cause havoc
> in Oracle.

Sure, but that was not my intent - I just think I
missunderstood the question.

Thanks for your help.
Chris Val