Re: external proc fails on 9.2 windows

Check out the EXTPROC_DLLS environment parameter in the net8 admin guide...

http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96580/advcfg.htm#483441

Tim

Jeffrey Beckstrom wrote:

> This is what we do in 8i and it works:
> CREATE OR REPLACE LIBRARY rta.nt_lib IS
> 'c:\windows\system32\kernel32.dll';
> /
> create or replace
> function rta.run(lpCmdLine IN varchar2, nCmdShow IN binary_integer) return
> binary_integer
> AS EXTERNAL
> NAME "WinExec"
> LIBRARY rta.nt_lib
> CALLING STANDARD PASCAL;
> /
> This is script we run....
> declare
> ret_bin binary_integer;
> cmd varchar2(600);
> begin
> /* main routine */
> cmd :='f:\temp\extproc_test.bat';
> ret_bin := rta.run(cmd,0);
> end;
> /
> Here is what the "bat" file being invoked contains:
> dir >f:\temp\extproc_test.log
>
> If do the same on a new server with 9.2 installed I get:
> ERROR at line 1:
> ORA-28576: lost RPC connection to external procedure agent
> ORA-06512: at "RTA.RUN", line 0
> ORA-06512: at line 10
>
> The extproc_test.log file is being created so it is running the bat
> file, just
> get an error though.
> Any ideas????
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113

-- 
Regards,
Tim Johnston
Tel: 978-322-4226
Fax: 978-322-4100


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------