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 DECEMBER 16, 2019

Applies to:

PL/SQL - Version 9.2.0.1 and later
Generic Windows
***Checked for relevance on 24-Aug-2017***

Purpose

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.

but even with these settings following error is seen during execution

ERROR at line 1:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to load DLL
ORA-06512: at "SCOTT.MYPROC", line 19
ORA-06512: at line 3

 

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

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