15.10 - Stored Procedure Overview - Teradata Database

Teradata Database SQL Stored Procedures and Embedded SQL

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1148-151K

A stored procedure, a database object executed on the Teradata Database, is a combination of SQL statements and control and condition handling statements that provide an interface to the Teradata Database.

Note: The term stored procedure refers to a stored procedure you write with SQL statements. The term external stored procedure refers to a stored procedure you write in C, C++, or Java.

Typically, a stored procedure consists of a:

  • Procedure name
  • Input and output parameters
  • Procedure body.
  • For each stored procedure, the database includes a stored procedure table that contains the stored procedure body you write and the corresponding compiled stored procedure object code. Data dictionary tables contain stored procedure parameters and attributes.