Re: Best way to execute a function

Sandy,

What's wrong with putting the function in a PL/SQL block? If the function is closely associated with a query I could see it being called as part of that query.

On 6/8/07, Sandra Becker <sbecker6925_at_gmail.com> wrote:
>
> RHEL 4.0, Oracle 9.2.0.8, Java.
>
> A developer just asked me the best way to execute a function. I can't say
> that I've ever seen it outside of a procedure and haven't found any
> information on another way to do it during my search this morning. He said
> he tried using a call statement, but couldn't get it to return any results.
> He is currently using the following statement:
>
> select pwrfunc.oragen_at_customersite(RPAD<pwrfunc.oragen_at_customersite%28RPAD>(?,
> 25)||RPAD(?, 25)||RPAD(?, 30)|| RPAD(?, 60)) from dual;
>
> Any suggestions?
>
> Sandy
>

-- 
Rumpi Gravenstein

--
http://www.freelists.org/webpage/oracle-l