external procedure call
I am do experience.It is about external procedure call.I have write a DLL and a PL/SQL script.This DLL is output two functions:sampleBeep()and sampleDelay().sampleBeep()function is sound.sampleDelay()function is delay some time.MY PL/SQL script as follow:
create or replace library samplelib is '\test_dll\sample.dll';
/
create or replace package demopack is
procedure sampleBeep;
procedure sampleDelay;
procedure demo_procedure;
end demopack;
/
show errors
create or replace package body demopack is
procedure sampleBeep is external name "sampleBeep" library samplelib;
procedure sampleDelay is external name "sampleDelay" library samplelib;
procedure demo_procedure is
begin
demopack.sampleBeep;
demopack.sampleDelay;
demopack.sampleBeep;
end demo_procedure;
end demopack;
/
show errors
execute demopack.demo_procedure;
/
In sql*plus,after run script,It report some error,please tell me how to correct it.error as follow:
SQL> @sample
?bRQ44=(!#
3LPr0|RQ44=(!#
C;SP4mNs!#
3LPr0|VwLeRQ44=(!#
C;SP4mNs!#
BEGIN demopack.demo_procedure; END;
*
ERROR N;SZ5Z 1 PP:
ORA-28595: Extproc agent : Invalid DLL Path
ORA-06512: TZ"SYSTEM.DEMOPACK", line 11
ORA-06512: TZ"SYSTEM.DEMOPACK", line 11
ORA-06512: TZline 1
3LPr0|VwLeRQ44=(!#
please help me,urgent!!!!