Minor Description
A statement like
create function s2.f2( char(8), integer) returns int
language java parameter style java external name 'myclass.mymethod'
fails with the message
ERROR 42X01: Syntax error: Encountered "char" at line 1, column 24
However
create function s2.f2( p1 char(8), p2 integer) returns int
language java parameter style java external name 'myclass.mymethod'
is accepted.
The Derby documentation (at http://incubator.apache.org/derby/manuals/reference/sqlj27.html#CREATE+PROCEDURE+Statement), the SQL2003 standard, and DB2 all agree that the parameter name is optional.