How to Execute Stored Procedures | Basic Teradata Query - Executing Stored Procedures - 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

Execute stored procedures either interactively, or include them in BTEQ scripts or input stream files.

Use the SQL CALL statement to execute a stored procedure interactively:

CALL samplesp1 (8888, pAmount);

If the procedure is created with parameters, specify the parameter arguments within the parenthesis.