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.
