Introduction to External Procedures

This chapter explains the external procedures provided in Tibero.

External Procedure is the functions users write in an external language (any programming language Tibero supports) such as C or Java programming languages. The procedure is treated as a PSM function (or procedure) in Tibero. Users can invoke the procedures when they want to use any user defined library. They can also get the processed result.

The external procedures in Tibero are used:

• To issue an event in the DBMS using email, SMS, and network.

• To compress a file depending on the size of the entire disk or the file, or to move it to an external disk.

• To use data encryption in applications.

---

External Procedure Types

The C language or the Java language is used to create external procedures in Tibero.

C External Procedure

• Executing C External Procedures

• Creating C External Procedures

• Example

Java External Procedure

• Executing JAVA External Procedures

• Creating JAVA External Procedures

• Example