HP Neoview Messages, Manual

Page: 249 / 400

Cause
During the execution of a CALL statement, an SPJ method returned result sets but
the result sets could not be processed because the language manager encountered an unexpected
error trying to retrieve the information for the result set at position
parameter-position
in the Java method signature.
Effect
The operation fails.
Recovery
Do not attempt recovery. HP support will perform recovery operations in response
to an automatically generated dial-out message about this condition.
SQL 11236
11236 Stored procedure procedure-name attempted to return too many
result sets. The maximum number of result sets this procedure can return
is max-results and the procedure body attempted to return
attempted-results.
procedure-name
is the ANSI name of a stored procedure.
max-results
is the maximum number of result sets that the procedure can return.
attempted-results
is the actual number of result sets that the SPJ method attempted
to return.
Cause During the execution of a CALL statement, the number of result sets returned from
an SPJ method exceeds the procedure’s declared maximum. The declared maximum was
specified in the DYNAMIC RESULT SETS clause of the CREATE PROCEDURE statement.
Effect The additional result sets are discarded.
Recovery No corrective action is required. This message is a warning. To reduce occurrences
of this message, you can change the SPJ method to return fewer result sets, or recreate the
procedure with a higher value for DYNAMIC RESULT SETS.
SQL 11238
11238 Stored procedure procedure-name attempted to return one or more
result sets containing large object data.
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
Neoview SQL and the result set contained large object data. The large object data types BLOB
and CLOB are not native data types in Neoview SQL and are not supported as stored-procedure
result-set column types.
Effect
The operation fails.
Recovery
Change the SPJ method to not return result sets containing large object data.
SQL 11239
11239 No compatible Java methods named method-name were found in Java
class class-name.
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
249