-840 More data returned than expected - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
ft:locale
en-US
ft:lastEdition
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

-840 More data returned than expected

Possible Cause

Data has been returned for a request but no output host variables are provided to receive the values, or data has been returned for an EXECUTE or EXECUTE IMMEDIATE request.

Possible Solution

Data may not be returned for an EXECUTE or EXECUTE IMMEDIATE request. If the dynamic statement is expected to return data, use a dynamic cursor. For all other requests, define host variables to receive the data.