16.20 - procedure_name - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

The calling name for the external procedure.

If the UDF library for your database contains any objects with multibyte characters in their name, you cannot use a single-byte session character set to create a new UDF, UDT, method, or Java stored procedure object even if the new object name contains only single-byte characters. If you attempt to do so, Teradata Database aborts the request and returns an error to the requestor. Instead, use a multibyte session character set.

For information about naming database objects, see Teradata Vantage™ SQL Fundamentals, B035-1141.

A procedure name is mandatory for all external procedures.

procedure_name must match the spelling and case of the C, C++, or Java procedure name exactly if you do not specify an external_procedure_name. This applies only to the definition of the procedure, not to its use.

database_name
An optional database name specified if the procedure is to be created or replaced in a non-default database.
If you do not specify a database name, Teradata Database creates or replaces the procedure within the current database.
user_name
An optional user name specified if the procedure is to be created or replaced in a non-default user.
If you do not specify a user name, Teradata Database creates or replaces the procedure within the current user.