Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)
| Chapter 21External 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.
| 21.4 Mapping Parameters | 21.6 External Procedure Housekeeping |
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.