#

| Chapter 21 External Procedures |

## 21.5 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.

21.4 Mapping Parameters |  | 21.6 External Procedure Housekeeping

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.