15.10 - procedure_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

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 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.