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

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.