OCI Service Routines

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.