PLSQL: Loading External Routine On Windows Fails With ORA-06520 / ORA-06522 Even If DLL Is Accessible And Placed Into %ORACLE_HOME%\bin and (ENV = "EXTPROC_DLLS=ANY") Has Been Added To Listener (Doc ID 1347492.1)

Last updated on MARCH 04, 2022

Applies to:

PL/SQL - Version 9.2.0.1 and later
Generic Windows

This note covers the situation where an external routine from a DLL should be called via PL/SQL and the configuration seems to be OK - i.e.

Listener configured properly
DLL containing external routine placed in %ORACLE_HOME%\bin of RDBMS
CREATE LIBRARY command resolved to storage location of DLL containing external routine using fixed path
(ENV = "EXTPROC_DLLS=ANY") has been added to the Listener running on RDBMS machine

but even with these settings following error is seen during execution

	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

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