Using Java External Procedures | CREATE PROCEDURE | Teradata Vantage - 17.10 - Rules for Creating a Java External Procedure - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
Java external procedures have 2 special requirements for creation or replacement that other types of external procedures do not.
  • The user who creates a Java external procedure must be the same user who registered its associated JAR file by calling SQLJ.Install_Jar (see JAR Files and SQLJ Database). This means that the jar_name you specify when you create the procedure must refer to a JAR file that you registered. If any other user registered the JAR file you specify, the CREATE/REPLACE PROCEDURE request aborts and returns an error to the requestor.
  • The containing database for any Java external procedure you create must match the default database at the time you register its JAR file using SQLJ.Install_Jar.