How to Execute Both 32-bit and 64-bit External Procedures within the Same Database
(Doc ID 250178.1)
Last updated on FEBRUARY 08, 2019
Applies to:PL/SQL - Version 22.214.171.124 and later
Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
***Checked for relevance on 24-Aug-2017***
This Note will walk through the required steps to set up a database to be able to execute both 32-bit and 64-bit External Procedures.
This example is applicable to any version from 9.0 onwards. Prior to that version the agent clause used in the create library call was not available.
Note that as of 188.8.131.52, the 32 bit extproc software is not shipped with the database by default but has to be installed separately - see <Note:884703.1> for details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|1. Create the shared libraries|
|1.1. Source files|
|1.2. Compile and build the required libraries|
|2. Configure The Listener|
|2.1 Update the listener.ora file|
|2.2 Update the tnsnames.ora|
|3. Log in, build the procedures and run the test|