On 5/28/16 11:05 AM, Danoja Dias wrote:
Hi All,
Is there a way to make optional arguments on system procedures? How
can we add new argument on a system procedure?
Any suggestion is very helpful.
--
Thanks,
Best Regards,
Danoja Dias.
Hi Danoja,
The last argument of a SQL routine (e.g., a function or a procedure)
can be a varargs argument. A varargs argument will match an invocation
which has 0 or more trailing arguments which have the type of the last,
varargs argument. The routine must be declared with parameter style
DERBY. See the section on CREATE PROCEDURE in the Reference manual:
http://db.apache.org/derby/docs/10.12/ref/rrefcreateprocedurestatement.html
What procedure do you have in mind?
Thanks,
-Rick
