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:
Allocates memory that will automatically de-allocate when control returns to PL/SQL.
Raises a predefined exception by its Oracle error number.
Raises a user-defined exception, including a custom error message.
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.
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.