My Oracle Support Banner

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 later
Oracle 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.