16.10 - Differences Between Stored Procedures and External Stored Procedures - Teradata Database

Teradata Database SQL Fundamentals

Teradata Database
Release Number
June 2017
Content Type
Programming Reference
Publication ID
English (United States)
Last Update
Using external stored procedures is very similar to using stored procedures, except for the following:
  • Invoking an external stored procedure from a client application does not affect the nesting limit for stored procedures.
  • To install an external stored procedure on a database, you must have the CREATE EXTERNAL PROCEDURE privilege on the database.
  • The CREATE PROCEDURE statement for external stored procedures is different from the CREATE PROCEDURE statement for stored procedures. In addition to syntax differences, you do not have to use the COMPILE command in BTEQ.