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 JANUARY 30, 2022

Applies to:

PL/SQL - Version and later
Oracle Database - Enterprise Edition - Version 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


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.



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, 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

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