Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Setup 10G to access external DLL on windows2000 - ORA-06520: PL/SQL: Error loading external library

Setup 10G to access external DLL on windows2000 - ORA-06520: PL/SQL: Error loading external library

From: news <here_at_there.com>
Date: Fri, 05 Aug 2005 17:59:05 GMT
Message-ID: <JNNIe.120818$5V4.120074@pd7tw3no>


Neither I nor the C coder that i am working with has attempted to setup an external procedure before so the help is greatly appreciated. Does the following error mean that oracle configuration is correct and now there is an issue with the DLL itself?

Unfortunately the C coder compiled on WinXP Pro and the 10G is on Win2000, any idea if this will work?

Error on line 0
begin
Call_Scaling_Factor (1,'NSLS','AP_OWNER','AP_OWNER', 'AP_CONS'); end;

ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to load DLL
ORA-06512: at "AP_OWNER.CALL_SCALING_FACTOR", line 1
ORA-06512: at line 2



Here is how i setup and called the extern proc in the db

CREATE OR REPLACE LIBRARY libscf AS
'C:\oracle\product\10.1.0\Db_1\BIN\ScalingFactorDLL.dll';

CREATE OR REPLACE PROCEDURE Call_Scaling_Factor (p_Settlement_Case_ID binary_integer, p_Profile_Types VARCHAR2, p_User VARCHAR2, p_Password VARCHAR2, p_Database VARCHAR2) AS EXTERNAL LIBRARY libscf
NAME "ScalingFactor"
LANGUAGE C
PARAMETERS (p_Settlement_Case_ID long, p_Profile_Types string,p_User string, p_Password string,p_Database string);

begin
Call_Scaling_Factor (1,'NSLS','AP_OWNER','AP_OWNER', 'AP_CONS'); end; Received on Fri Aug 05 2005 - 12:59:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US