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:

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.


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.