Neoview Messages Manual (Volume 1) (R2.4)

parameter types. If the DYNAMIC RESULT SETS clause specifies a value greater than 0 (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 11235
11235 The Language Manager encountered an unexpected error trying to
retrieve information for the result set at position parameter-position
in the Java method signature.
parameter-position
is the position of the result set parameter in the Java method
signature.
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.
233