db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: And another metadata question
Date Thu, 02 Feb 2006 17:40:56 GMT
Daniel John Debrunner wrote:

> David W. Van Couvering wrote:
>>Does Derby support calling user-defined stored procedures or functions
>>using the stored procedure escape syntax?
> Yes for procedures, search for the reqular expression '\{.*call' in
> procedure.java.
> Possibly for functions, since I'm modifying functions.sql I can add some
> tests there to see.

Yes for functions, of course it has to be a java test because the syntax is
 {? = call function(...) }

(to fetch the out parameter, ij doesn't support getting the parameter).

This is already tested in outparams.java


View raw message