Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5924817280 for ; Mon, 26 Jan 2015 22:59:57 +0000 (UTC) Received: (qmail 67374 invoked by uid 500); 26 Jan 2015 22:59:57 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 67181 invoked by uid 500); 26 Jan 2015 22:59:57 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 67016 invoked by uid 99); 26 Jan 2015 22:59:57 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Jan 2015 22:59:57 +0000 Date: Mon, 26 Jan 2015 22:59:57 +0000 (UTC) From: "Myrna van Lunteren (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Comment Edited] (DERBY-3005) Document possibility to specify method signature in EXTERNAL NAME when creating a procedure/function MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14292574#comment-14292574 ] Myrna van Lunteren edited comment on DERBY-3005 at 1/26/15 10:59 PM: --------------------------------------------------------------------- updates are in the latest alpha manuals. resolving. was (Author: myrna): 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)