How to Execute Both 32-bit and 64-bit External Procedures Within The Same 11.2 and Above Database
(Doc ID 1109144.1)
Last updated on FEBRUARY 03, 2022
Applies to:PL/SQL - Version 184.108.40.206 and later
Information in this document applies to any platform.
This Note is to demonstrate how to execute both 64-bit and 32-bit external procedures.
Currently the following two notes exist for executing both 32-bit and 64-bit external procedures within a single database.
<Note.250178.1> How to execute both 32-bit and 64-bit External Procedures within the same 9i, 10g and 11.1 database.
Each new version of Oracle has made it easier for executing 64-bit external procedures and with version 11.2 it is by far the easiest as there is no more configuring of the listener and tnsnames file. However, you must define the environment variables to be used by external procedures in the extproc.ora file located in the ORACLE_HOME/hs/admin directory.
Although progress has been made for the setup/configuration of 64-bit external procedures, there is now an extra step required when executing 32-bit external procedures. Previous versions of Oracle would install both 64-bit and 32-bit components. A typical installation would provide both the extproc executable (for 64-bit External Procedures) as well as the extproc32 executable (for 32-bit External Procedures). With version 11.2, only the 64-bit components are installed which means only the extproc executable is provided. To get the 32-bit components a separate install is required. Normally the 32-bit libraries can be installed into the same Oracle Home as the 64-bit but not with version 11.2 because the 32-bit extproc32 executable has been renamed to extproc and since these get installed in the ORACLE_HOME/bin directory the 32-bit extproc would overwrite the 64-bit extproc executable.
This note will first demonstrate a very simple 64-bit external procedure. The same sample codes used in the previous notes is used here as well to make it easier to spot any differences in the setup. Afterward, this note will continue to describe what is required to execute a 32-bit external procedure as well as some additional tips.
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