Best way to execute a function
- From: "Sandra Becker" <sbecker6925@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Jun 2007 08:47:38 -0600
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@customersite(RPAD(?, 25)||RPAD(?, 25)||RPAD(?, 30)||
RPAD(?, 60)) from dual;
Any suggestions?
Sandy
Other related posts:
