External stored procedures are written in the C, C++, or Java programming language, installed on the database, and then executed like stored procedures.
Here is a synopsis of the steps you take to develop, compile, install, and use external stored procedures:
- Write, test, and debug the C, C++, or Java code for the procedure.
- If you are using Java, place the class or classes for the external stored procedure in an archive file (JAR or ZIP) and call the SQLJ.INSTALL_JAR external stored procedure to register the archive file with the database.
- Use CREATE PROCEDURE or REPLACE PROCEDURE for external stored procedures to create a database object for the external stored procedure.
- Use GRANT to grant privileges to users who are authorized to use the external stored procedure.
- Invoke the procedure using the CALL statement.