You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Satheesh Bandaram (JIRA)" <de...@db.apache.org> on 2005/05/04 23:49:07 UTC

[jira] Updated: (DERBY-183) Parameter names required in CREATE FUNCTION

     [ http://issues.apache.org/jira/browse/DERBY-183?page=all ]

Satheesh Bandaram updated DERBY-183:
------------------------------------

    Component: SQL

> Parameter names required in CREATE FUNCTION
> -------------------------------------------
>
>          Key: DERBY-183
>          URL: http://issues.apache.org/jira/browse/DERBY-183
>      Project: Derby
>         Type: Bug
>   Components: SQL
>     Versions: 10.0.2.0
>     Reporter: Jack Klebanoff
>     Priority: Minor

>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira