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 "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2015/01/26 23:59:56 UTC

[jira] [Resolved] (DERBY-3005) Document possibility to specify method signature in EXTERNAL NAME when creating a procedure/function

     [ https://issues.apache.org/jira/browse/DERBY-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Myrna van Lunteren resolved DERBY-3005.
---------------------------------------
       Resolution: Fixed
    Fix Version/s: 10.12.0.0

results are in the latest alpha manuals. resolving.

> Document possibility to specify method signature in EXTERNAL NAME when creating a procedure/function
> ----------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3005
>                 URL: https://issues.apache.org/jira/browse/DERBY-3005
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.4.1.3
>            Reporter: Kristian Waagan
>            Assignee: Myrna van Lunteren
>             Fix For: 10.12.0.0
>
>         Attachments: DERBY-3005.diff, DERBY-3005_2.diff, rrefsqljexternalname.html, rrefsqljexternalname.html
>
>
> In some cases it might be necessary to specify the method signature of the external method used as a function or procedure in Derby (using CREATE FUNCTION or CREATE PROCEDURE).
> This possibility is not documented in the manuals, but there is an entry in the FAQ (http://db.apache.org/derby/faq.html#null_args):
> Either declare the function with RETURNS NULL ON NULL INPUT or define the Java method signature in the external name clause. See the "Create function problem"  derby-user mail list topic.
> The mail thread: http://mail-archives.apache.org/mod_mbox/db-derby-user/200602.mbox/%3c4404E53D.1050605@apache.org%3e
> The relevant sections in the manuals should be updated to describe the feature.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)