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
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
klx1480972732157.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval
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.