SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Trigger, UDR Server, and Language Manager
Messages (11000 through 11399)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
13-27
Where max-results is the maximum number of result sets that the procedure can
return.
Where 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. Additional result sets are discarded.
Recovery. None. This message is issued as a warning. If desired, change the SPJ
method to return fewer result sets, or re-create the procedure with a higher value for
DYNAMIC RESULT SETS.
SQL 11237
Where procedure-name is the ANSI name of a stored procedure.
Cause. During the execution of a CALL statement, an SPJ method returned result
sets but the result sets could not be processed because the version of JDBC/MX in the
SPJ environment does not support stored procedure result sets.
Effect. The operation fails.
Recovery. Change the version of JDBC/MX in the SPJ environment to one that
supports stored procedure result sets.
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.
11237 Stored procedure procedure-name attempted to return
result sets but the JDBC/MX driver in the SPJ environment
does not support stored procedure result sets.
11238 Stored procedure procedure-name attempted to return one
or more result sets containing large object data.