On 12/4/15 6:38 PM, Anjana Prakash wrote:
Hi,
Is it possible to write user define System Procedure . I know user
define function are possible however we are looking for calling our
procedure in same way as
Existing system procedure.
Any doc or any other reference would be useful.
Thanks,
Anjana
A Derby user-defined procedure is just a public static void Java method.
The syntax for declaring a user-defined procedure may be found here:
http://db.apache.org/derby/docs/10.12/ref/rrefcreateprocedurestatement.html
More information on writing, calling, and deploying user-defined
procedures may be found here:
http://db.apache.org/derby/docs/10.12/devguide/cdevspecial.html
Hope this helps,
-Rick