SQL/MX 2.x Messages Manual (H06.10+, J06.03+)

Trigger, UDR Server, and Language Manager Messages
(11000 through 11399)
HP NonStop SQL/MX Messages Manual—544518-011
12-26
SQL 11238
where,
procedure-name is the ANSI name of a stored procedure.
Cause. During the execution of a CALL statement, an SPJ method returned a result
set to SQL/MX and the result set added large object data. The large object data types,
BLOB and CLOB, are not native data types in SQL/MX and are not supported as
stored procedure result set column types.
Effect. The operation fails.
Recovery. Change the SPJ method, which will not return result sets containing large
object data.
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,
11238 Stored procedure procedure-name attempted to return one
or more result sets containing large object data.
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[].