16.20 - Rules for Creating a Java External Procedure - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
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.