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 22.214.171.124 and later
***Checked for relevance on 24-Aug-2017***
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
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
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