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

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Published
June 2017
Content Type
Programming Reference
Publication ID
B035-1141-161K
Language
English (United States)
Last Update
2018-04-25
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.