Purpose
Invokes an SQL procedure or external stored procedure.
Required Privileges
You must have the EXECUTE PROCEDURE privilege on the procedure or its containing database or user.
Users need not have any privileges on the database objects referenced by a called procedure. The privileges are checked for the immediate owner of the called procedure.
The immediate owner must have the privileges on the referenced objects WITH GRANT OPTION to allow other users to access the object.
For more information, see SQL Data Definition Language and Database Administration .
Privileges Granted Automatically
If you call the SQLJ.Install_Jar procedure to install a JAR file containing classes that implement a Java external stored procedure, the DROP PROCEDURE privilege is automatically granted to the creator of the JAR file (the caller of SQLJ.Install_Jar).
Syntax
Syntax Elements
- database_name
- user_name
- optional qualifier for the SQL procedure or external procedure to be executed.
- procedure_name
- Name of the SQL procedure or external procedure to be executed.
- value_expression
- Teradata Database-supported arithmetic and string expressions.
- ?
- A call parameter argument.
- out_call_variable
- An identifier prefixed with the COLON (:) character.
- out_call_placeholder
- A parameter name.
- parameter_name
- The name of the OUT parameter as defined in the SQL procedure.
- CAST … AS
- The request to convert the data definition of a parameter or another CAST clause to the required type. CAST clauses can be nested.
- data_type
- The data definition for the parameter set. All Teradata Database-supported data types are valid.
ANSI Compliance
CALL is ANSI SQL:2011-compliant.