"news" <here_at_there.com> wrote in message
news:JNNIe.120818$5V4.120074_at_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;
>
>
Is the DLL statically linked?
That is, does the DLL dynamically load other DLL's (dynamic linking)?
If it's not statically linked Oracle will not load it.
--
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---
WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup
Received on Fri Aug 05 2005 - 16:44:51 CDT
