21.5 OCI Service Routines

Chapter 21
External Procedures

 

---

There are four OCI routines that you can use in your external procedures. These require that you have passed context area information to the C function by including WITH CONTEXT in your PL/SQL body. The routines are:

OCIExtProcAllocCallMemory

Allocates memory that will automatically de-allocate when control returns to PL/SQL.

OCIExtProcRaiseExcp

Raises a predefined exception by its Oracle error number.

OCIExtProcRaiseExcpWithMsg

Raises a user-defined exception, including a custom error message.

OCIExtProcGetEnv

Allows an external procedure to perform OCI callbacks to the database to execute SQL or PL/SQL.

Refer to Oracle's PL/SQL User's Guide and Reference for detailed documentation and examples of using these routines.