Best way to execute a function

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(?, 25)||RPAD(?, 25)||RPAD(?, 30)|| RPAD(?, 60)) from dual;

Any suggestions?

Sandy

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