Change the execution mode for the specified external procedure from unprotected mode to protected mode.
The EXECUTE PROTECTED option causes the external procedure to execute as a separate process. For details, see the ALTER PROCEDURE (External Form) topic “When to Specify Unprotected Mode” in Teradata Vantage™ SQL Data Definition Language Detailed Topics , B035-1184 .
An external SQL procedure linked with CLIv2 can only execute in protected mode.
A Java external SQL procedure can only execute in protected mode.
- NOT
- Change the execution mode for the specified external procedure from protected mode to unprotected mode. The EXECUTE NOT PROTECTED option causes the external procedure to execute directly on the Teradata Database.
Example: Altering the Protection Mode of an External Procedure
This example changes the protection mode of the C-language external procedure named my_xsp from protected to not protected.
ALTER PROCEDURE my_xsp LANGUAGE C EXECUTE NOT PROTECTED;