Sybase Adaptive Server Anywhere - Page 475

Chapter 9 SQL Statements
457
DYNAMIC RESULT SETS clause This clause is for use with procedures
that are wrappers around Java methods. If the DYNAMIC RESULT SETS
clause is not provided, it is assumed that the method returns no result set.
EXTERNAL NAME LANGUAGE JAVA clause A procedure that uses
EXTERNAL NAME with a LANGUAGE JAVA clause is a wrapper around
a Java method.
If the number of parameters is less than the number indicated in the method-
signature then the difference must equal the number specified in DYNAMIC
RESULT SETS, and each parameter in the method signature in excess of
those in the procedure parameter list must have a method signature of
[Ljava/sql/ResultSet;.
A Java method signature is a compact character representation of the types of
the parameters and the type of the return value.
The field-descriptor and return-descriptor have the following meanings:
Field type Java data type
B
byte
C
char
D
double
F
float
I
int
J
long
Lclass-name; an instance of the class class-name. The class name must be fully
qualified, and any dot in the namemust be replaced by a /. For
example, java/lang/String
S
short
V
void
Z
boolean
[
use one for each dimension of an array
For example,
double some_method(
boolean a,
int b,
java.math.BigDecimal c,
byte [][] d,
java.sql.ResultSet[] d ) {
}