Stored Procedure Compilation | Basic Teradata Query - Stored Procedure Compilation - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

The Stored Procedure Language (SPL) compilation errors and warnings are reported by the database as part of the SUCCESS or OK parcel in response to the COMPILE command.

All syntax and semantic errors in the stored procedure source text are reported with a non-zero warning code. The activity count is set to the total number of compilation errors and warnings.

The database server reports SPL compilation errors and warnings, which are stored in a buffer. If the errors and warnings exceed the buffer size limit, the server returns only the errors and warnings stored in the buffer. Additional errors and warnings are not stored in the buffer or returned to the user, including, the last error or warning text, if it does not fit in the buffer. A message is displayed when too many compilation errors occur. Refer to the Vantage Database manuals for additional details, including the current buffer capacity.

The stored procedure is not created or replaced if compilation errors are found. Instead, the stored procedure is created or replaced if compilation warnings are found, and no failures are reported.