Stored Procedure

Teradata Developer Guides

ft:locale
en-US
ft:lastEdition
2026-08-18

<db:stored-procedure>

Invokes a stored procedure on the database. When the stored procedure returns one or more ResultSet instances, results are not read all at once. Instead, results are automatically streamed to prevent performance and memory issues. This behavior means that pages of _fetchSize_ rows are loaded lazily when needed. If the Stored procedure operation is performed inside a transaction (for example, in a Try scope component), and that transaction is closed before consuming the data, accessing the results that haven't been loaded will fail.