DYNAMIC RESULT SETS integer
Derby Reference Manual
34
The procedure owner and the
automatically gain the EXECUTE privilege
on the procedure, and are able to grant this privilege to other users. The EXECUTE
privileges cannot be revoked from the procedure and database owners.
For details on how Derby matches procedures to Java methods, see
Syntax
CREATE PROCEDURE
procedure-Name
( [
ProcedureParameter
[,
ProcedureParameter
] ] * )
[
ProcedureElement
] *
procedure-Name
. ]
If schema-Name is not provided, the current schema is the default schema. If a qualified
procedure name is specified, the schema name cannot begin with SYS.
ProcedureParameter
[ { IN | OUT | INOUT } ] [ parameter-Name ] DataType
The default value for a parameter is IN. ParameterName must be unique within a
procedure.
The syntax of DataType is described in
.
Note: Data-types such as BLOB, CLOB, LONG VARCHAR, LONG VARCHAR FOR BIT
DATA, and XML are not allowed as parameters in a CREATE PROCEDURE statement.
ProcedureElement
{
| [ DYNAMIC ] RESULT SETS
| LANGUAGE { JAVA }
|
DeterministicCharacteristic
| EXTERNAL NAME string
| PARAMETER STYLE JAVA
| EXTERNAL SECURITY { DEFINER | INVOKER }
| { NO SQL | MODIFIES SQL DATA | CONTAINS SQL | READS SQL DATA }
}
DYNAMIC RESULT SETS integer
Indicates the estimated upper bound of returned result sets for the procedure. Default is
no (zero) dynamic result sets.
LANGUAGE
JAVA- the database manager will call the procedure as a public static method in a Java
class.
EXTERNAL NAME string
String describes the Java method to be called when the procedure is executed, and takes
the following form:
class_name.method_name
The External Name cannot have any extraneous spaces.
DeterministicCharacteristic
DETERMINISTIC | NOT DETERMINISTIC
Declares that the procedure is deterministic, meaning that with the same set of input
values, it always computes the same result. The default is NOT DETERMINISTIC. Derby
