My Oracle Support Banner

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


Troubleshooting Steps

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
Troubleshooting Steps

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