15.10 - procedure_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

The name of the procedure to be recompiled. 
The SQL procedure you specify must already exist, must have been created with the SPL compile-time option, and cannot be an external procedure. You can recompile only one SQL procedure at a time.

database_name
The name of a qualifying database containing the SQL procedure to be altered. If database_name is not specified, the default database for the current session is assumed.
user_name
The name of a qualifying database containing the SQL procedure to be altered. If user_name is not specified, the default user for the current session is assumed.
LANGUAGE SQL
The procedure body is written in the SQL language. This clause is optional.
SQL DCL and DDL statements for administering row-level security are not allowed in a stored procedure.