Skip to Main Content

SQL & PL/SQL

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!

Help !!! unknow error number ORA-28595

385152Jan 10 2003 — edited Jan 10 2003
Hi,

i try to execute a procedure PL/SQl 9i.
This procedure should open Notepad executable by running an API Windows .

The result is :
-----------------
SQL> execute sp_test_os_command;
BEGIN sp_test_os_command; END;

*
ERREUR ligne 1 :
ORA-28595: Extproc agent : Invalid DLL Path
ORA-06512:   "INTERFACE.RUN_OS_COMMAND", ligne 0
ORA-06512:   "INTERFACE.SP_TEST_OS_COMMAND", ligne 4
ORA-06512: ligne 1

Can you help me, please !!!!!!!!!
My code :
-----------
create or replace library kernel32 is 'c:\winnt\system32\kernel32.dll';

CREATE OR REPLACE FUNCTION "INTERFACE"."RUN_OS_COMMAND" (cmd in
VARCHAR2, show in binary_integer default 0)
return binary_integer
as external library KERNEL32
name "WinExec"
language C;

CREATE OR REPLACE PROCEDURE "INTERFACE"."SP_TEST_OS_COMMAND" as
test binary_integer;
begin
test:=run_os_command('notepad.exe',2);
end;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2003
Added on Jan 10 2003
1 comment
1,798 views