15.00 - Rules for Creating a Java External Procedure - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Rules for Creating a Java External Procedure

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” on page 432 and “SQLJ Database” on page 435). 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.