db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan J Debrunner <ddebrun...@sbcglobal.net>
Subject Re: calling a function
Date Tue, 03 Oct 2006 00:15:16 GMT


--- Jim McNamara <3rdshiftcoder@verizon.net> wrote:

> hi-
>  
> I set up this function in squirellSQL.
>  
> CREATE FUNCTION DISTRIBTOTALAMOUNT() RETURNS DOUBLE
> PARAMETER STYLE JAVA
> 
> READS SQL DATA LANGUAGE JAVA EXTERNAL NAME
> 'bcalc.DistGetTotalAmount.getTotal'
>  
> if I try to call it in squirrelSQL like this call
> DISTRIBTOTALAMOUNT() I
> get not
> recognized as a function or a procedure.

CALL is used for procedures, not functions.

You can use VALUES to execute a function like this:

VALUES DISTRIBTOTALAMOUNT()

This page might also help:

http://wiki.apache.org/db-derby/DerbySQLroutines

Dan.

Mime
View raw message