Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-28595: Extproc agent : Invalid DLL Path

68267Nov 21 2002
I have a dll,which writed by vc++60.I am doing exeperiments about external procedure call.I have write some PL/SQL code which is according to oracle sample,but when we run it,there are some errors:
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=(!#

I have look through internet about this error,but I have not correct this error.
my platform:windows 2000 server
oracle:9.2 personal edition
my sql program as follow:
create or replace library samplelib is 'e:oracle\ora92\bin\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;
/

please tell me how to correct this problem,I need detailed information.
please help me !!!!
give me detailed example about listener.ora and tnsname.ora,and tell me detailed step how to correct problem.
It is important to me .

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2002
Added on Nov 21 2002
1 comment
2,140 views