SAP Knowledge Base Article - Preview

2176042 - Stored procedure returns error when called as derived table - SAP IQ


  • Stored procedure executes successfully when called like this: exec myproc

  • The procedure fails when called like this: select * from myproc()

The 3 possible errors are:

  • Value 33005 out of range for destination

  • Right truncation of string data

  • myproc returned a result set with a different schema than expected



SAP IQ All Versions


SAP IQ all versions


KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.