15.00 - 7682 OPEN/EXECUTE/DEALLOCATE PREPARE attempted on a unprepared dynamic sql in the stored procedure (%FSTR). - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

7682 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.

Remedy:

PREPARE the dynamic sql statement before using OPEN or DEALLOCATE PREPARE statement and resubmit the request.