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

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.1.3
• Fix Version/s: 10.12.1.1
• Component/s: Documentation
• Assignee: Myrna van Lunteren
• Reporter: Kristian Waagan
• Created: 14/Aug/07 12:29
• Updated: 09/Sep/16 09:53
• Resolved: 26/Jan/15 22:59

Description

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/[e-mail]%3e

The relevant sections in the manuals should be updated to describe the feature.

Issue Links

• is related to: DERBY-1197 Problem while setting NULL in PreparedSattement for java.sql.Types.Integer