HP NonStop SQL/MX, Messages Manual

Page: 357 / 752

Trigger, UDR Server, and Language Manager
Messages (11000 through 11399)
HP NonStop SQL/MX Messages Manual — 640324-001
13 -27
SQL 11239
Where
method-name
is the Java method name specified in the EXTERNAL NAME
clause of a CREATE PROCEDURE statement.
class-name
is the Java class name specified in the EXTERNAL NAME clause of a
CREATE PROCEDURE statement.
Cause. During the execution of a CREATE PROCEDURE statement that includes a
DYNAMIC RESULT SETS clause that specifies a value greater than 0 (zero), an SPJ
method having one or more trailing result sets could not be found in the specified Java
class. The SPJ method must be named
class-name.method-name
and must have
a Java type signature that matches the declared SQL parameter types. If the
DYNAMIC RESULT SETS clause specifies a value greater than zero, the SPJ method
must also have one or more trailing
java.sql.ResultSet[]
parameters.
Effect. The operation fails.
Recovery. Ensure that the SPJ method exists in the specified class file, and resubmit.
SQL 11240
Where
index
is the ordinal position of the parameter specified in the EXTERNAL
NAME clause of a CREATE PROCEDURE statement.
Cause. The parameter at position
index
is not
java.sql.ResultSet[]
.
Effect. The operation fails.
Recovery. Ensure that the specified signature trailing parameters are specified as
Java type
java.sql.ResultSet[]
, and resubmit.
SQL 11241
Where
procedure-name
is the ANSI name of a stored procedure.
Where
ver1
and
ver2
are the SPJ RS interface version numbers of the JDBC/MX
driver.
11239 No compatible methods method-name were found in Java
class class-name .
11240 Specified signature is invalid. Reason: Parameter at
position
index is not java.sql.ResultSet[].
11241 Stored procedure procedure-name attempted to return
result sets but the JDBC/MX driver in the SPJ environment has
an incompatible version of stored procedure result sets
interface. The JDBC/MX driver's interface version is
ver2 and
the expected version is ver1 or lower.