Yes, this looks about right. You'd need the java.math.BigDecimal type on the input to accommodate the DECIMAL input.
Cf. http://db.apache.org/derby/docs/10.6/ref/rrefcreatefunctionstatement.html http://db.apache.org/derby/docs/10.6/ref/rrefsqlj15260.html Good luck! Dag
