Help with External Procedures

I am having problems with using external procedures.

For testing I have created a simple DLL which I know works.

#define DllExport __declspec( dllexport )

DllExport int Test()
{
 return 12;
}

Then in Oracle done the following

create or replace library planet_utils as 'c:\winnt\pldll.dll';
/

CREATE OR REPLACE FUNCTION Test RETURN BINARY_INTEGER AS EXTERNAL LIBRARY planet_utils
NAME "Test"
LANGUAGE C;
/

create or replace procedure test_dll as l_count binary_integer;
begin
l_count := Test;
end;
/

exec test_dll

ERROR at line 1:

ORA-06521: PL/SQL: Error mapping function
ORA-06522: Unable to load symbol from DLL
ORA-06512: at "TACCHI.TEST", line 0
ORA-06512: at "TACCHI.TEST_DLL", line 4
ORA-06512: at line 1

Does anybody have any ideas on what the problem is

Cheers

Andrew Tacchi Received on Mon Jan 25 1999 - 10:53:42 CST