16.10 - Executing Stored Procedures - Teradata Database

Teradata Database SQL Fundamentals

Teradata Database
Release Number
Release Date
June 2017
Content Type
Programming Reference
Publication ID
English (United States)

If you have sufficient privileges, you can execute a stored procedure from any supporting client utility or interface using the SQL CALL statement. You can also execute a stored procedure from an external stored procedure written in C, C++, or Java.

You have to specify arguments for all the parameters contained in the stored procedure.

Here is an example of a CALL statement to execute the procedure created in “Defining a Stored Procedure for New Employees”:

   CALL NewProc ('Jonathan', 1066, 34, dname);