ORA-06522: Unable to load DLL
662114Sep 26 2008 — edited Sep 26 2008{color:#0000ff}Hi All,
I'm hoping that one of you bright sparks may be able to help me with this one. First off here's the error:
{color}
Error starting at line 1 in command:
execute BW3Status
Error report:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to load DLL
ORA-06512: at "TIA.BANKWIZARD3", line 118
ORA-06512: at "TIA.BW3STATUS", line 5
ORA-06512: at line 1
06520. 00000 - "PL/SQL: Error loading external library"
*Cause: An error was detected by PL/SQL trying to load the external
library dynamically.
*Action: Check the stacked error (if any) for more details.
{color:#0000ff}I know you have to setup listener / tnsnames / and setup a library, this is how I've got them setup:
LISTENER
{color}
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
(ENVS="EXTPROC_DLLS=C:\Program Files\Experian Payments\Bank Wizard\Core\bwintora.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TIA-DEVELOPER)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_AGENT))
)
)
{color:#0000ff}TNSNAMES{color}
TIADB01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tiadb01)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_AGENT))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
{color:#0000ff}LIBRARY:{color}
CREATE OR REPLACE LIBRARY bwint10 AS 'C:\Program Files\Experian Payments\Bank Wizard\Core\bwintora.dll';
{color:#0000ff}I'm executing a test simply by running execute BW3Status; Which is a test stored proc provided by the third party.
OK. Now I know the dll is in the correct place, and I've restarted the machine after I made my changes. The dll is from a third party who assures me it works, and has done for years as it's a test wrapper to use thier software.....
Anyone have any idea what I've done wrong?
Cheers
Craig.{color}