How to Execute Both 32-bit and 64-bit External Procedures within the Same Database
(Doc ID 250178.1)
Last updated on OCTOBER 09, 2023
Applies to:
PL/SQL - Version 9.2.0.8 and laterOracle Database - Enterprise Edition - Version 9.2.0.8 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
Generic UNIX
Purpose
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.
Scope
NOTE: This article does *not* apply to Windows platform. Installing a 32 bit Oracle Database on Windows 64bit is not certified. Reference <Document 1307195.1>
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 11.2.0.1, 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
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
Purpose |
Scope |
Details |
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 |
References |