Calling functions and procedures

Derby supports the CALL (procedure) statement for calling external procedures declared by the CREATE PROCEDURE statement. Built-in functions and user-defined functions declared with the CREATE FUNCTION command can be called as part of an SQL select statement or by using either a VALUES clause or VALUES expression.

Related concepts
Dynamic SQL
Cursors
Information schema
Transactions
Stored routines and PSM
Unique constraints and nulls
NOT NULL characteristic
DECIMAL max precision
CLOB and BLOB
Expressions on LONGs
ALTER TABLE