On 18 Nov 2002 11:31:56 -0500 Jeff Seger <[EMAIL PROTECTED]> wrote: > Maybe I am missing something herre (It is Monday after all) but > shouldn't a function be called in a select statement: > > "select OWNER.MY_FUNCTION(?,$action,?,$meta_type) from dual" > > or something similar? > > On Mon, 2002-11-18 at 10:43, Michael A Chase wrote:
>> You are not providing anything to receive the value returned by the >> function. You will need either a PL/SQL variable that will be discarded or >> a bind variable as shown in the examples in >> http://search.cpan.org/author/TIMB/DBD-Oracle-1.12/Oracle.pm and >> http://search.cpan.org/src/TIMB/DBD-Oracle-1.12/Oracle.ex/proc.pl . Look at the function examples in the URIs I cited. PL/SQL functions can often be used in a SELECT, but not always. Unless you are getting arguments for the function from a table, there is no advantage to using a SELECT instead of an anonymous block and there may be some additional overhead. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
