Oracle PL/SQL Programming, 2nd Edition

Oracle PL/SQL Programming, 2nd EditionSearch this book
Previous: 21.4 Mapping ParametersChapter 21
External Procedures
Next: 21.6 External Procedure Housekeeping

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:


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.

Previous: 21.4 Mapping ParametersOracle PL/SQL Programming, 2nd EditionNext: 21.6 External Procedure Housekeeping
21.4 Mapping ParametersBook Index21.6 External Procedure Housekeeping

The Oracle Library Navigation

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference
This HTML Help has been published using the chm2web software.