db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: using sql statement in procedure or function
Date Fri, 04 Aug 2006 02:16:29 GMT
Ivan Ooi wrote:
> hi all,
>   Is there anyway that i can use SQL statement to query my data in 
> procedure or function ?
> Will Derby going to implement that ? Why not take a look JoSQL.sf.net 
> <http://JoSQL.sf.net>,
> good if Derby can take this library in :-)
> Thanks
Hi -
The Derby WIKI page on Procedures and Functions is a good place to look 
for information and examples of doing this.

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

You will need to use a Procedure to return multiple values - a function 
can only return a single value.

View raw message