In this blog post, let’s learn about the error message “11238 Stored procedure procedure-name attempted to return one or more result sets containing large object data.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11238 Stored procedure procedure-name attempted to return one or more result sets containing large object data.
Reason for the Error
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.
Solution
Change the SPJ method, which will not return result sets containing large object data
