Teradata Database Message 7682 - 7682 - Analytics Database - Teradata Vantage

Analytics Database Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
15.xx,16.xx,17.xx
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-01-05
dita:mapPath
sfx1628096178347.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-1096
lifecycle
latest
Product Category
Teradata Vantageā„¢
Message
OPEN/EXECUTE/DEALLOCATE PREPARE attempted on a unprepared dynamic sql in the stored procedure (%FSTR).
Explanation
The stored procedure in execution is trying to OPEN a cursor, EXECUTE, or DEALLOCATE PREPARE using a dynamic sql which is not prepared yet.
Generated By
RTS Modules.
For Whom
End User.
Notes
None
Remedy
PREPARE the dynamic sql statement before using OPEN or DEALLOCATE PREPARE statement and resubmit the request.